Save extra with 1 Offers
Get ₹ 50
Instant Cashback on the purchase of ₹ 400 or aboveProduct Specifications
| Publisher | PHI Learning All Information Technology books by PHI Learning |
| ISBN | 9788120345423 |
| Author: | Rajeeb C. Chatterjee |
| Number of Pages | 398 |
| Available | Available in all digital devices |
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.
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
