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.
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
Höhe: 229 mm
Breite: 190 mm
Gewicht
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 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 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.
