SQL refers to SQL statements that are embedded directly
within the programming language to allow that language to access and modify
data within an SQL database.
Embedding SQL directly into program source code is very
common in procedural database languages such as Oracle PL/SQL or Microsoft
Transact-SQL. lt is also possible to embed SQL into other languages such as C.
PL/SQL stands for Procedural Language extension of SQL.
PL/SQL is a combination of SQL along with the procedural features of
programming languages. It was developed by Oracle Corporation in the early 90's
to enhance the capabilities of SQL. PL/SQL is Oracle's procedural language
extension to Oracle SQL. PL/SQL stands for Procedural Language/SQL. PL/SQL
extends SQL by adding constructs found in procedural languages, resulting in a
structural language that is more powerful than SQL.
It allows using all the SQL data manipulation statements as
well as the cursor control operations and transaction processing. PL/SQL blocks
can contain any number of SQL statements. It allows logically grouping a number
of SQL sentences and passing them to the DBA as a single block. The basic unit
in PL/SQL is a block. All PL/SQL programs are made up of bleat which can be
nested within each other. Typically, each block performs a logical action in
the program.
Every programming environment allows the creation of
structured, logical blocks of code that describe processes. which have to be
applied to data. Once these blocks are passed to the environment, the processes
described are applied to data, suitable data manipulation takes place, and
useful output is obtained.
PL/SQL Permits the creation of structured logical blocks of
code that describe Processes, which have to be applied to data. A single PL/SQL
code block consists of a set of SQL statements clubbed together. and passed to
grouped together tort engine entirely. This block has to be logically to
recognize it as a singular code block. A PL/SQL block has a definite structure.
which can be divided into sections.