Preface Acknowledgements 1. Introduction to DBMS and RDBMS 2. Installation of Oracle 10g XE (Express Edition) 3. Introduction to Oracle 4. Oracle Data Types 5. Oracle Operators 6. Integrity Constraints 7. Oracle Built-in Functions 8. Adding, Deleting and Modifying Records 9. Sorting 10. Table Operations—Altering Structure 11. Joins 12. Advanced Queries Using Special Operators 13. Indexing 14. Oracle Security—Privileges 15. Oracle Security—Roles 16. Sequences and Synonyms 17. Views and Materialized Views 18. SQL Plus Reporting 19. PL/SQL 20. Stored Functions 21. Stored Procedures 22. Oracle Packages 23. Exception Handling in PL/SQL 24. Cursors 25. Database Triggers 26. Oracle Flashback Technology 27. Normalization 28. Entity Relationship Diagram (ERD) 29. Oracle FAQ 30. Oracle 11g New Features 31. Installation of Oracle Database 12c 32. New Features in Oracle 12c 33. Working More with CDB and PDBs 34. Plugging and Unplugging PDBs 35. Transaction Handling Index.