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.

Chapter 1:  Introduction to Oracle Database

Chapter 2:  Introduction to SQL Plus

Chapter 3:  Retrieving Data in SQL

Chapter 4:  Data Manipulation and Transaction

Chapter 5:  Creating & Managing Schema Objects

Chapter 6:  Built-in Functions in Oracle

Chapter 7:  Introduction to PL/SQL

Chapter 8:  Exception Handling in PL/SQL

Chapter 9:  Cursors and Triggers

Chapter 10:  PL/SQL Subprograms

Chapter 11:  PL/SQL Packages

Chapter 12:  Oracle Database Security

Index

Sham Tickoo