Pl Sql Tutorial

What is PL/SQL

PL/SQL (Procedural Language/Structured Query Language) is a procedural language created by Oracle. PL/SQL allows data manipulation and query from SQL procedures to be included in stucturate blocks.


General features:

-PL/SQL Constructs contain procedural control structures and descriptive SQL commands;

-PL/SQL procedural language is a structured block, programs can be divided into logical blocks;

-PL/SQL Blocks are processed by the engine of the PL/SQL that may be resident on the ORACLE SERVER or on a tool development (e.g. Oracle JDeveloper, Reports);

-Many tools have their own ORACLE PL/SQL engine (e.g. Oracle Forms, Reports, JDeveloper);

-Data types in SQL can be used in PL/SQL;

-You can define variables and structures of type arrays indexed and record in memory.

-Allows defining the elements of type Cursor for individual and sequential processing of registrations resulting from the interogarile SQL

-Provide the definition of programmes, procedures and stored functions in BD

-Allow the control of information and access to higher level through procedures of type TRIGGER associated commands change.

-Allows the definition of classes of user objects, which allow the implementation of the concept of relational databases obiectuale.

Access to PL/SQL is made by users via SQL * Plus and not directly.In PL/SQL is only run their own commands, and the SQL commands that access the database run on SQL Server. PL/SQL has several hundreds of functions and procedures.

Programming resources: Sql Plus Tutorial,  Oracle Tutorial,  TSQL Tutorial,  PL/SQL Tutorial,  MySQL Tutorial,  SQL Tutorial,  SQLite Tutorial