Category: 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

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…

PL/SQL Uncategorized

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…

PL/SQL

PL/SQL Uncategorized

When you create a schema, it may be possible that you forget to add some columns or constraints in a table. SQL Alter Table Statement gives you the capability to…

SQL

PL/SQL

PL/SQL architecture defines how the PL/SQL blocks are executed in Oracle. Oracle provides PL/SQL engine that executes the Procedural Language part of a block. When an application program or a…

DBMS PL/SQL