Oracle8 The complete reference

Summary of contents

• Part 1 Critical database contents: sharing knowledge and success
• the dangers in a relational database
• Part 2 SQL-going from beginner to expert: the basic parts of speech in SQL
• the basics of object-relational databases
• basic SQLPLUS reports and commands
• getting text information and changing it
• playing the numbers
• dates - then, now, and the difference
• conversion and transformation functions
• grouping things together
• when one query depends upon another
• some complex possibilities
• building a report in SQLPLUS
• changing data - insert, update and delete
• advanced use of functions and variables
• DECODE - amazing power in a single word
• creating, dropping and altering tables and views
• by what authority
• changing the ORACLE surroundings
• SQLPLUS
• assessing remote data
• an introduction to P1/SQL
• triggers
• procedures
• implementing types, object views, and methods
• collectors (nested tables and varying arrays)
• using large objects (LOBs) in ORACLE8
• snapshots
• using ConText for text searches
• configuring the ConText option
• advanced object-oriented concepts in ORACLE8
• Part 3 The hitchhiker's guide to the ORACLE8 data dictionary
• Part 4 Designing for productivity
• good design has a human touch
• performance and design
• the hitchhiker's guide to the ORACLE optimiser
• Part 5 Alphabetical reference
• Appendix: tables used in this book