Oracle 12c/11g/10g. PL/SQL Programming

Overview

PL/SQL (Procedural Language/SQL) is a programming language that is used to access and work with Oracle databases from different environments. PL/SQL extends the functionality of the SQL language by adding structures of typical procedural languages, such as variables and types , control structures (loops , arrays IF- THEN- ELSE , etc. .), Procedures and functions, types objects and methods and other classical structures in procedural programming languages . It is a robust and powerful language that combines the flexibility of SQL with the power and configurability of procedural constructs.

The book starts at a basic level with the idea of introducing the reader step by step through the programming of Oracle taking him by the hand to achieve an advanced level. It will start showing the introduction of code in the SQL
• Plus environment and the extensive development of entity-relationship model through Oracle SQL which is the mainstay of programming in relational databases. Also, it is exhaustively procedural programming language PL/SQL Oracle, which extends the standard SQL language. The following general topics:

ORACLE ENVIRONMENT. RELATIONAL DESIGN
ORACLE PL / SQL ELEMENTS
PL / SQL STRUCTURE
BLOCKS IN PL / SQL
LEXICAL UNITS
TYPES (DATATYPES) AND CONVERSIONS
FORMATS
ASCII and EBCDIC CHARACTERS IN ORACLE PL / SQL
VARIABLES
EXPRESSIONS AND OPERATORS IN ORACLE PL / SQL
PRESET FUNCTIONS IN ORACLE PL / SQL
CONTROL STRUCTURES IN PL / SQL
LOOPS
RECORDS, TABLES AND MATRIX IN PL / SQL
VARRAYS
SQL IN PL / SQL
SLIDERS IN PL / SQL
SUBPROGRAMMES
PROCEDURES
FUNCTIONS
PACKAGES
TRIGGERS
EXCEPTIONS
PL / SQL DYNAMIC
PL / SQL AND JAVA

Read More