Oracle Database 10g SQL
Jason Price · CERN Document Server (European Organization for Nuclear Research) · 2004
This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download. Table of contents Ch. 1: Introduction Ch. 2: Retrieving Information from TablesCh. 3: Using Simple FunctionsCh. 4: Storing and Processing Dates and TimesCh. 5: Using SQL *Plus Ch. 6: Subqueries Ch. 7: Advanced Select Functions Ch. 8: Changing Table Contents Ch. 9: Database SecurityCh. 10: Creating Database Tables, Indexes, Views, and Sequences Ch 11: Introducing PL/SQL ProgrammingCh. 12: Database ObjectsCh. 13: Collections Ch. 14: Large Objects Ch 15: Native XML SupportCh. 16: Tuning Appendix A Oracle Data Types