Learning Oracle 12C-PL/SQL APPROACH - 2nd Revised & Updated Edition

This Textbook aims at familiarizing the Students and professional developers with SQL and PL/SQL. This textbook provides a detailed explanation of the basic as well as advanced features of SQL and PL/SQL such as Data manipulation and transaction, schema objects (Sequences, Views, Materialized Views and Synonyms) built-in functions, exception handling, cursors and triggers, subprograms and so on. The systematic explanation of source code with suitable examples, a unique feature of the textbook, enables students to gain a thorough and practical understanding of Oracle. Moreover, the Chapters in the textbook are structured in a pedagogical sequence that makes it very effective in learning the key features and capabilities of the Oracle database.

1. Introduction to Oracle Database
2. Introduction to SQL Plus
3. Retrieving Data in SQL
4. Data Manipulation and Transaction
5. Creating & Managing Schema Objects
6. Built-in Functions in Oracle
7. Introduction to PL/SQL
8. Exception Handling in PL/SQL
9. Cursors and Triggers
10. PL/SQL Subprograms
11. PL/SQL Packages
12. Oracle Database Security
Index

Sham Tickoo