Description
BPB Publications Java Programming Simplified by Dr. Muneer Ahmad Dar
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