• PHI Learning Oracle SQL and PL/SQL : A Simplified Guide  PHI Learning Oracle SQL and PL/SQL : A Simplified Guide 

PHI Learning Oracle SQL and PL/SQL : A Simplified Guide 

Product Code : 9788120345423

Availability: In stock

Regular Price: Rs. 350

Special Price: Rs. 333

Quick Overview

PHI Learning Oracle SQL and PL/SQL : A Simplified Guide 

The book offers a systematic knowledge of Oracle SQL and PL/SQL to help students exploit the capabilities of the database in an effective and efficient manner. The book follows a step-by-step approach to the subject using real-world cases, examples and exercises in order to make it an easy, interesting and complete self-study guide.

The book can be used for practical classes on Oracle version 8.0 onwards. The availability of an authorized Oracle database in conjunction with the book is sufficient to learn Oracle commands and syntaxes. It is designed to address the need of the laboratory classes on Oracle for the students of Computer Science, Information Technology and Computer Applications.

The book will also be useful to professionals and academics alike for conducting training programmes on Oracle database.



1. Introduction
2. Create Table Structure
3. Alter Table Structure
4. Insert a Row
5. Update Rows
6. Delete Rows
7. Query from Tables
8. Built-in Number Functions
9. Built-in Character Functions
10. Built-in Date Functions
11. Built-in Conversion Functions
12. Built-in Group Functions
13. Subquery
14. Advanced Join Methods
15. View
16. Sequence
17. Index
18. Synonym
19. Security
20. System Tables
21. SQL*Plus
22. Introduction to PL/SQL
23. Control Structures
24. Procedure
25. Function
26. Package
27. Trigger
28. Cursor
29. Introduction to Oracle Architecture

Read more See more product details


Brand / Publisher PHI Learning
Return Policy 30 Days
Book Type Reference Books
Edition 2015
ISBN 9788120345423
Author Prof : Chatterjee
Language English
Study Stream Engineering
Specialization Computer Science
Subject Computer Science
Pages 388
Binding Paperback


Brand Description

Established in 1963, PHI Learning is a leading academic publisher of the country. Under the imprint of Eastern Economy Editions, PHI Learning has been the pioneer of low-cost high quality affordable texts. PHI titles encompass a wide range of subjects including engineering, sciences, humanities, management, computer science & information technology, social sciences and books for working professionals. With more than 3000 titles on its list today, PHI has often played a pivotal role in redesigning and reorienting university syllabi based on its valuable books.
  1. Be the first to review this product

Write Your Own Review

Only registered users can write reviews. Please, log in or register