Introduction Of PL/SQL



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.