Learning Oracle SQL and PL/SQL  (English, Paperback, Chatterjee Rajeeb C.)

This book offers a systematic knowledge of the 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 many real-world cases, examples and exercises in order to make this text a complete and effective self-study guide.

The book can also 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, syntaxes, operators, built-in function, techniques for creation, alterations and uses of table structures. Screenshots are not presented in the book to avoid confusion due to differing platforms that the students may use in different environments.

Designed to address the need of the laboratory classes on Oracle for the students of Computer Science, Information Technology and Computer Applications, this book will also be useful to professionals and academics alike for conducting training programmes on Oracle databases.

About The Author
RAJEEB C. CHATTERJEE, Former Senior Consultant, PricewaterhouseCoopers Limited, Kolkata, is presently a visiting faculty in the Department of Information Technology, Jadavpur University. He has more than 20 years of teaching experience and a vast practical experience in developing industry-oriented application software using Oracle and other databases. He is an active member of the database community for more than two decades. His areas of interest include databases management systems and software engineering.

Table Of Contents

Preface
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
Answers to Revision Exercises
Index