Oracle 11g: A PL/SQL Approach

(with line_by_line explanation of the source code)
Sham Tickoo
, Purdue University Calumet and
CADCIM Technologies, USA
Published by CADCIM Technologies, USA

ISBN  978-1-932709-62-9
Paperback, 512 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 11g: A PL/SQL Approach
is an example-based textbook written to cater 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 have been covered in the textbook that will enable the readers to take full advantage of this cutting-edge technology.

The following are some additional features of this book:
   Each concept discussed in the book is exemplified by an application to clarify and facilitate better understanding.  

·    This textbook introduces the key ideas to create database applications  in an innovative way. The concepts are illustrated
       through best examples, covering the basic as well as advance aspects of Oracle.

·    Additional information is provided to the users in the form of notes.

·    There is an extensive use of examples, schematic representation, screen captures, tables, and programming exercises. 

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:   Built-in Functions in Oracle
         Chapter 6:   Introduction to PL/SQL
         Chapter 7:   Exception Handling in PL/SQL

         Chapter 8:   Cursors and Triggers
         Chapter 9:   PL/SQL Subprograms
Chapter 10:
PL/SQL Packages
         Chapter 11: Oracle Database Security


Free Teaching and Learning Resources
CADCIM Technologies provides the following free teaching and learning resources for the faculty
 Online technical support by contacting techsupport@cadcim.com
 All applications used in exercises and examples
 Customizable PowerPoint presentations of all chapters in the textbook (For faculty members only)
 Instructor’s Guide with solutions to all review questions and exercises in the textbook (For faculty members only)

Evaluation Chapters of  Learning Oracle 11g: A PL/SQL Approach textbook
 (Note: These are Zipped pdf files)
  toc-oracle, c02-oraclec03-oracle
Application Files
All Applications used in the chapters
c02-oraclec03-oracle, c04-oraclec06-oracle,
, c09-oraclec10-oracle,
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.