In what cursor attributes the outcomes of DML statement execution are saved? What is the difference between a mutating table and a constraining table? What are COMMIT, ROLLBACK and SAVEPOINT statements in PL/SQL? Differentiate between the cursors declared in procedures and the cursors declared in the package specifications. What are the virtual tables available during the execution of the database trigger? What is the difference between ROLLBACK and ROLLBACK TO statements in PL/SQL? What are the various functions available for manipulating the character data? What is the importance of %TYPE and %ROWTYPE data types in PL/SQL? Differentiate between implicit cursor and explicit cursor. Can you explain the PL/SQL execution architecture? What is the purpose of WHEN clause in the trigger? How do you write comments in a PL/SQL code? When does a DECLARE block become mandatory? What is a Trigger? Name some instances when “Triggers” can be used. How can a name be assigned to an unnamed PL/SQL Exception Block? What is the use of WHERE CURRENT OF in cursors? Explain the basic structure followed in PL/SQL?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |