Contents at a Glance..............................................................................................iii
Contents.................................................................................................................iv
About the Authors............................................................................................... xvii
Acknowledgments ............................................................................................... xix
Introduction ......................................................................................................... xxi
Chapter 1: Relational Database Systems and Oracle..............................................1
Chapter 2: Introduction to SQL, AQL*Plus, and SQL Developer.............................25
Chapter 3: Data Definition, Part I..........................................................................71
Chapter 4: Retrieval: The Basics...........................................................................83
Chapter 5: Retrieval: Functions ..........................................................................117
Chapter 6: Data Manipulation .............................................................................145
Chapter 7: Data Definition, Part II.......................................................................163
Chapter 8: Retrieval: Multiple Tables and Aggregation ......................................195
Chapter 9: Retrieval: Some Advanced Features .................................................233
Chapter 10: Views...............................................................................................265
Chapter 11: Writing and Automating SQL*Plus Scripts ......................................287
Chapter 12: Object-Relational Features..............................................................329
Appendix A: The Seven Case Tables ...................................................................349
Appendix B: Answers to the Exercises ...............................................................359
Index...................................................................................................................40
- Log in to post comments