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.
-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.