Oracle 7
The Complete Reference
2nd Edition
Published on 1. March 1993
Book
Paperback/Softback
1072 pages
978-0-07-881919-3 (ISBN)
Description
This reference work presents information on ORACLE, the most widely used SQL (Structured Query Language) database worldwide. Users and developers should find information to help them get the most from this powerful program. The author provides an extensive alphabetical reference to all of ORACLE's major products, concepts, commands, functions, operators, key words and definitions. This book covers all the major features of the latest version. Readers will also find chapters with extensive examples on using, designing, and maintaining databases effectively. This is a plain-English guide that shows users and developers how to tap into the ample power of ORACLE and exploit its full potential. Part 1 begins with a review of critical database concepts, and is intended for both users and developers. Part 2 describes all aspects of SQL (Structured Query Language), from beginning concepts to expert techniques. Part 3 teaches developers the key methods for creating successful user-based applications. Part 4 provides tips and advanced techniques for developing with ORACLE products.
Part 5 contains an extensive alphabetical reference of ORACLE's commands, functions, and definitions with plenty of cross-references and examples. Part 6 provides a complete list of tables used in the book.
Part 5 contains an extensive alphabetical reference of ORACLE's commands, functions, and definitions with plenty of cross-references and examples. Part 6 provides a complete list of tables used in the book.
More details
Edition
2nd Revised edition
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Professional and scholarly
Edition type
Revised edition
Illustrations
tabs.
Dimensions
Height: 230 mm
ISBN-13
978-0-07-881919-3 (9780078819193)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Part 1 Critical database concepts: sharing knowledge and success; the dangers in a relational database. Part 2 SQL - going from beginner to expert: the basic parts of the speech in SQL; basic SQLPLUS reports and commands; getting texts 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. Part 3 Designing for productivity: good design has a human touch; performance and design; the ten commandments of humane design. Part 4 Developing with ORACLE products - tips and advanced techniques: SQL*PLUS; SQL*FORMS. Part 5 Alphabetical reference: alphabetical reference. Part 6 Appendix: tables used in this book.