PL/SQL Cursors PL/SQL uses implicit and explicit cursors. PL/SQL declare a implicit cursor for each operation to data manipulation in SQL. If you want precise control over the queries, you can declare a explicit cursor; You can define a explicit cursor...
PL/SQL Stored Procedures Stored procedures are called blocks that allow grouping and organization of SQL and PL/SQL commands. Stored Procedure CREATE OR REPLACE PROCEDURE proc_name (paramater_name datatype, ...) IS BEGIN -- pl/sql statement END; Parameters are used to transfer data between...
PL/SQL Functions A function is a PL/SQL block with names that accept parameters, can be called in a select and can return a value. Functions and procedures are similar structures. A function may return a single value, while a procedure may...
PL/SQL Packages The package consists of grouped objects as procedures, functions, variables, exceptions, cursors. Each package consists of two parts: – Specification of the package – Here we can declare public types, variables, constants and exceptions. – The body of the...
PL/SQL Exception Handling Exception Handling in PL/SQL refers to the concept of exception. The exception is an error or an warning message generated by the server or application. Exceptions may be defined, enabled, treated at the level of each block in...