Understanding Oracle

Understanding Oracle is a thorough,up –to –date introduction to Oracle relational database management system, featuring its full implementation of ANSI       standard SQL (Structured Query Language). Written especially for microcomputer users, this comprehensive treatment of SQL will also be of value to users of Oracle on minicomputers and mainframes. Understanding Oracle user clear, hands-on examples from business applications – inventory management,program planning ,personnel management and more –to show you all need to know to: Design and create useful Oracle data tables, including how to enter and edit information, and – Use SQL and SQL Plus commands to retrieve selected data Join multiple tables for complex applications Create views show you just the data you need             Table of Contents                 Introduction             Oracle :The Right Tool For Many Jobs             Installing Professional Oracle             Interfacing With Oracle SQL and SQL Plus             Designing a Database Creating Tables, and Adding Data             Querying the Database             Defining And Using Views             Operators And Functions             Understanding SQL Forms             Using SQL ReportWriter             Using SQL Menu             Maintaining Database Security             Optimizing System Performance: Indexing and Clustering             Programming With Oracle : Using PRO *C             Oracle Utilities :EXP,IMP, ODL And SQL*Loader             Oracle for 1-2-3             Using the Spreadsheet :SQL*CALC