3 Review(s)

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