Related InterviewSolutions

• 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?
• What is a PL/SQL cursor?
• Explain the basic structure followed in PL/SQL?
• What do you understand by PL/SQL table?
• What are the features of PL/SQL?