Learning Oracle 12c: A PL/SQL Approach, 2nd Edition
Sham Tickoo
, Purdue University Northwest and
CADCIM Technologies, USA
Published by CADCIM Technologies, USA

ISBN  978-1-942689-39-3
Paperback, 592 Pages

Please give us your email address and we will keep you informed about the  material added to this web page

mailto: sales@cadcim.com

Click to see Full Image

Learning Oracle 12c: A PL/SQL Approach
is an example-based textbook written to cater to the needs of the students and the professional developers who want to develop database management applications using Oracle SQL and PL/SQL. The chapters in this textbook are structured in a pedagogical sequence, which makes the learning process very simple and effective for both the novice as well as the advanced users of Oracle. In addition, the book follows the PL/SQL approach that will help you develop database applications with improved performance. A wide range of features of SQL and PL/SQL such as data manipulation and transaction, built-in functions, exception handling in PL/SQL, cursors and triggers, subprograms, and so on have been covered in the textbook that will enable the readers to take full advantage of this cutting-edge technology.

It is a comprehensive textbook with rich information about Oracle and is written in an easy to- read format supported by hints and illustrations. The highlight of the textbook is that each concept introduced in it is explained with the help of suitable examples to clarify concepts and facilitate better understanding. The simple and lucid language used in the textbook makes it a ready reference for both the beginners and the intermediate users.

Salient Features:

  • Consists of 12 chapters which introduce the key ideas of the Oracle SQL and PL/SQL in an innovative way.
  • The concepts are illustrated through best programming examples, covering the basic as well as advanced concepts of Oracle.
  • The first page of every chapter summarizes the topics that are covered in it.
  • Each concept introduced has been explained with the help of examples, thus making it an ideal guide for the beginners as well as experienced users.
  • Additional information is provided throughout the book in the form of tips and notes.
  • Self-Evaluation Test and Review Questions are given at the end of each chapter so that the users can assess their knowledge.

Table of Contents
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

Free Teaching and Learning Resources

CADCIM Technologies provides the following free teaching and learning resources with this textbook:

  • Technical support by contacting techsupport@cadcim.com
  • All programs used in examples
  • Customizable PowerPoint Presentations of every chapter (For faculty only)
  • Instructor's Guide with solutions to all review questions and exercises (For faculty only)
Evaluation Chapters of  Learning Oracle 12c: A PL/SQL Approach textbook
 (Note: These are Zipped pdf files)
Program Files
All Programs used in the examples
c02_oracle_12c_exmp.zip    c03_oracle_12c_exmp.zip
c04_oracle_12c_exmp.zip    c05_oracle_12c_exmp.zip
c07_oracle_12c_exmp.zip    c08_oracle_12c_exmp.zip

c09_oracle_12c_exmp.zip    c10_oracle_12c_exmp.zip
c11_oracle_12c_exmp.zip    c12_oracle_12c_exmp.zip
Free Technical Support
For free technical support, please email to
Click here to order  

If you find any problems in downloading the files or the contents, please contact us at techsupport@cadcim.com. Thank you.