Interview questions on PL/SQL
Difference between Syntax and Runtime errors in PL/SQL?? Explain what is COMMIT, ROLLBACK and SAVEPOINT?? How many types of Triggers are there in PL/SQL and what are they? How to generate Debugging Information in PL/SQL? In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented? Name any 5 PL/SQL exception types What are the two different types of Exceptions in PL/SQL? What is IN parameter and OUT parameter in PLSQL? What is Public and Private Procedures in PL/SQL? What is Referential Integrity? What is SQLCODE and SQLERRM in PL/SQL? What is the difference between CASE and DECODE? What is the difference between VARCHAR and VARCHAR2 in PL/SQL? What is %TYPE and %ROWTYPE in PL/SQL?? What is the disadvantage of using %ROWTYPE in PL/SQL? What are the advantages of using %TYPE and $ROWTYPE in PL/SQL? List all different types of Data Types in PL/SQL? What is the difference between Views and Materialized Views in Oracle? What is difference bet