Oracle7 For Dummies shows you how to unleash the power of your Oracle7 database. Get practical advice on creating a solid relational database. You'll find examples of SQL that you can run on any Oracle7 platform, from PC to UNIX to IBM mainframes. Save time as you discover Oracle's unique features, without the confusion. Whether you use Oracle at home or at work, this down-to-earth reference gives you easy-to-understand answers at your fingertips. Even experienced programmers can use the performance-tuning tricks found in this book!

Inside, find helpful advice on how to

• Discover dozens of real examples of SQL code
• Follow step-by-step instructions for using Personal Oracle7 Navigator
• Apply SQL Plus examples and instructions for all Oracle7 platforms
• Get advice and guidelines for expert relational database designs
• Develop tuning tips on how best to use indexing of columns
• Gain practical advice on database security issues, such as roles and table privileges
• Follow the how-to guide for diagramming your database design in clear, simple steps
• Understand foreign keys and primary keys explained in clear, precise language
• Includes CDROM and Cheat Sheet

Annotation

For anyone whose job requires working with a powerful database built on the Oracle database software, this . . . For Dummies guide will make getting around the application easier, because simple and easy-to-cover instructions cover all the primary features and commands.