How do you declare a user-defined exception?
You can declare the User defined exceptions under the DECLARE section, with the keyword EXCEPTION. Syntax: EXCEPTION;
PL/SQL Interview Questions
What will you get by the cursor attribute SQL%NOTFOUND?
It returns the Boolean value TRUE if no rows were processed.
What are some predefined exceptions in PL/SQL?
A list of predefined exceptions in PL/SQL: DUP_VAL_ON_INDEX ZERO_DIVIDE NO_DATA_FOUND TOO_MANY_ROWS CURSOR_ALREADY_OPEN INVALID_NUMBER INVALID_CURSOR PROGRAM_ERROR TIMEOUT _ON_RESOURCE STORAGE_ERROR LOGON_DENIED VALUE_ERROR
What will you get by the cursor attribute SQL%FOUND?
It returns the Boolean value TRUE if at least one row was processed.
What do you understand by PL/SQL packages?
A PL/SQL package can be specified as a file that groups functions, cursors, stored procedures, and variables in one place.
What is PL/SQL?
PL/SQL stands for procedural language extension to SQL. It supports procedural features of programming language and SQL both. It was developed by Oracle Corporation in early of 90’s to enhance the capabilities of SQL.
What is a trigger in PL/SQL?
A trigger is a PL/SQL program which is stored in the database. It is executed immediately before or after the execution of INSERT, UPDATE, and DELETE commands.
What are the two different parts of the PL/SQL packages?
PL/SQL packages have the following two parts: Specification part: It specifies the part where the interface to the application is defined. Body part: This part specifies where the implementation of the specification is defined.
What is the purpose of using PL/SQL?
PL/SQL is an extension of SQL. While SQL is non-procedural, PL/SQL is a procedural language designed by Oracle. It is invented to overcome the limitations of SQL.