Learning Oracle 12C-PL/SQL APPROACH

Author:

Prof. Sham Tickoo

,

TIET

Publisher:

BPB Publications

Rs849 Rs999 15% OFF

Availability: Out of Stock

Out of Stock

    

Rating and Reviews

0.0 / 5

5
0%
0

4
0%
0

3
0%
0

2
0%
0

1
0%
0
Publisher

BPB Publications

Publication Year 2017
ISBN-13

9789386551177

ISBN-10 9789386551177
Binding

Paperback

Number of Pages 592 Pages
Language (English)
Weight (grms) 1080

This textbook aims at familiarizing the students and professional developers with SQL and pathologies/SQL. This textbook provides a detailed explanation of the basic as well as advanced features of SQL and pathologies/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: br>Chapter 1: Introduction to Oracle database br>Chapter 2: Introduction to SQL plus br>Chapter 3: retrieving data in SQL br>Chapter 4: Data manipulation and transaction br>Chapter 5: creating & managing schema objects br>Chapter 6: built-in functions in Oracle br>Chapter 7: Introduction to pathologies/SQL br>Chapter 8: exception handling in pathologies/SQL br>Chapter 9: cursors and triggers br>Chapter 10: pathologies/SQL subprograms br>Chapter 11: pathologies/SQL packages br>Chapter 12: Oracle database security index.

Prof. Sham Tickoo

TIET

No Review Found
More from Author