Your shopping cart is empty.

Learning Oracle 12c A PL/SQL Approach - 2nd Revised & Updated Edition By Sham Tickoo

Rs. 630.00

Author: Sham Tickoo


  • Language: English
  • Binding: Paperback
  • Publisher: BPB Publications
  • ISBN: 9789386551177
  • Edition: 2017
  • Pages: 412
  • Dimension: 24 X 19 X 3 cm


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 text book, 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 Oracle database.

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