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.
Auflage
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Editions-Typ
Illustrationen
Maße
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 Klassifikation
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.
