Compare sql and pl/sql, PL-SQL Programming

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

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
Related Questions
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: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

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 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 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 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 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: 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

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 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