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…
Category: <span>SQL</span>
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…
All the cursors declared by PL/SQL for SQL statements of a PL/SQL block are called Implicit Cursors. A programmer doesn’t need to write Open, Fetch and Close operations to manage…
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 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…
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…
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 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…
In addition to PL/SQL variables and constants, you can use variables in two ways. PL/SQL Substitution and Bind Variables allow you pass on values to PL/SQL programs while execution. Lets…
Variables and constants are the most important lexical elements in any programming language. The ability to declare and use variables by PL/SQL is one of its advantages over SQL. We…