Oracle
The Complete Reference
3rd Edition
Published on 1. March 1995
Book
Paperback/Softback
1050 pages
978-0-07-882097-7 (ISBN)
Description
An alphabetical reference of Oracle commands, functions, syntax, key words, concepts and products. The book includes a review of critical database concepts and an overview of SQL, as well as insider's tips and techniques for developing Oracle products. Throughout the text are extensive examples of the effective use, design and maintenance of databases. Also included are examples of how Oracle's gateway capabilities allow users to transparently integrate new and existing data, systems and applications.
More details
Edition
3rd 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
Illustrations
Dimensions
Height: 229 mm
Width: 190 mm
Weight
1520 gr
ISBN-13
978-0-07-882097-7 (9780078820977)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
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 speech in SQL; 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. Part 3 Designing for productivity: good design has a human touch; performance and design; distributed database design; the ten commandments of humane design. Part 4 Developing with Oracle products - tips and advanced techniques: SQL*PLUS; Oracle - new and improved. Part 5 Alphabetical reference. Part 6 Appendices: tables used in this book; Oracle guide.