Category: PL/SQL

Triggers which are executed only once for all rows in the transaction are called Statement Level Triggers. These triggers, when fired, make changes in the affected row in one go.…

PL/SQL

PL/SQL Trigger is block of code attached to an event that may occur on a data table.   Trigger is a stored block with [Declare], Begin, End and Associated with a…

PL/SQL

There are two types of exceptions in PL/SQL Built-in Exceptions and User-Defined Exceptions. Built-in exceptions are predefined in Oracle with a exception (error code) and its details. User Defined exceptions…

PL/SQL

PL/SQL Exception is a run-time error caused due to many things that occur in a database application. It can be due to wrong data stored in variables, incorrect data accessed…

PL/SQL

A cursor named and declared in a PL/SQL block’s declare section is called an Explicit Cursor. The explicit cursors must be declared, opened, fetched and closed. The management of PL/SQL…

PL/SQL Uncategorized

PL/SQL cursors are internal data structures used to execute SQL statements. SELECT statements in PL/SQL programs are implicit cursors. They represent memory areas used by SQL processor to execute SQL…

PL/SQL

PL/SQL Iterative control statements allow a programmer to execute a set of statements multiple times. All iterative statements must have a conditional statement to check whether to continue to execute…

PL/SQL

Like any procedural programming language, PL/SQL programs can also using Branching structures to control flow of logic. The conditional or branching statements of PL/SQL are IF-THEN-END IF IF-THEN-ELSE-END IF IF-THEN-ELSIF-END…

PL/SQL

Programming in PL/SQL requires you to understand the existence and availability of declared variables for correct coding. PL/SQL variable scope and visibility lets you understand where and when the variables…

PL/SQL

PL/SQL variables can be declared in two ways. First one is by using the in-built data types. Second method is by using existing database objects in variable declaration instead of…

PL/SQL