ORACLE 12c/11g/10g. PL/SQL PROGRAMMING

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