Question 1. Compare SQL and PL/SQL

Question 2. Write a database trigger to implement the following check condition

                         Given the following table

                         Empno       Empname       Joining Date

Every time the user enters the employee number in the above table, it should check that it is always >1 and <200

Question 3. Differentiate between shared pool and large pool of Oracle memory component

Question 4. Write about the following Oracle 9i objects

• Logical Storage Structures
• Database Blocks
• Physical Storage Structures

Question 5. Write a query using oracle SQL to compute the number of months between September 29,1999 and August 17, 2003

Question 6. Write a select statement in oracle SQL that returns each instructors last name followed by a comma and a space, followed by instructor's first name all in single column in the result set

Posted Date: 11/6/2013 5:27:30 AM | Location : United States

Ask an Expert

Related Discussions:- Compare sql and pl/sql, Assignment Help, Ask Question on Compare sql and pl/sql, Get Answer, Expert's Help, Compare sql and pl/sql Discussions

Write discussion on Compare sql and pl/sql
Your posts are moderated

Write your message here..

Related Questions

Package specification, The Package Specification The package specificat... The Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to t

Parameter and keyword description - exit statement, Parameter and Keyword D... Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

Packages, Packages The package is a schema object which groups logicall... Packages The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the bod

Declarations in sql-pl/sql, Declarations in SQL Your program stores value... Declarations in SQL Your program stores values in the variables and constants. As the program executes, the value of the variables can change, but the values constants cannot.

Passing cursor parameters, Passing Cursor Parameters You use the OPEN ... Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Using for update, Using FOR UPDATE If you declare a cursor which will ... Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an

Using savepoint, Using SAVEPOINT The SAVEPOINT names and marks the pre... Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

Selecting objects in pl sql, Selecting Objects: Suppose that you have ... Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE

Character types, ROWID and UROWID Internally, every database table has ... ROWID and UROWID Internally, every database table has a ROWID pseudo column that stores binary values known as rowids. Each rowid shows the storage address of a row. A physical

Data types in sql - timestamp, Data Types in SQL - Timestamp TIMESTAMP... Data Types in SQL - Timestamp TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2