What is difference between a PROCEDURE & FUNCTION ?
What is Raise_application_error ?
Name the tables where characteristics of Package, procedure and functions are stored ?
State the difference between implicit and explicit cursor's.
How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
What is difference between stored procedures and application procedures,stored function and application function?
Explain the usage of WHERE CURRENT OF clause in cursors ?
Explian rowid,rownum?What are the pseduocolumns we have?
State the advantage and disadvantage of Cursor?
How many types of database triggers can be specified on a table ? What are they ?
Explain how procedures and functions are called in a PL/SQL block ?
How to debug the procedure ?
Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons
What is trigger,cursor,functions in pl-sql and we need sample programs about it?
Next>>
