You can declare the User defined exceptions under the DECLARE section, with the keyword EXCEPTION. Syntax: EXCEPTION;
PL/SQL Interview Questions
It returns the Boolean value TRUE if no rows were processed.
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
It returns the Boolean value TRUE if at least one row was processed.
A PL/SQL package can be specified as a file that groups functions, cursors, stored procedures, and variables in one place.
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.
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.
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.
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.