Mastering Oracle SQL and SQL*Plus

1. Corrected Auflage, Corr. 2. printing 2005
ISBN: 978-1-59059-448-3
Verlag: Apress

Buch, Englisch, 468 Seiten, Format (B × H): 193 mm x 260 mm, Gewicht: 1017 g

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database.

Zielgruppe

Popular/general

Autoren/Hrsg.

deHaan, Lex

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Prozedurale Programmierung
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung Oracle

Inhaltsverzeichnis

1. Relational Database Systems and Oracle
2. Introduction to SQL, iSQL*Plus, and SQL*Plus
3. Data Definition, Part I
4. Retrieval: The Basics
5. Retrieval: Functions
6. Data Manipulation
7. Data Definition, Part II
8. Retrieval: Multiple Tables and Aggregation
9. Retrieval: Some Advanced Features
10. Views
11. SQL*Plus and iSQL*Plus

Über Autor(innen)

Lex de Haan studied applied mathematics at the University of Technology in Delft, the Netherlands. His experience with Oracle goes back to the mid-1980s, version 4. He worked for Oracle Corporation from 1990 to 2004 in various education-related roles, ending up in Server Technologies (product development) as senior curriculum manager for the advanced database administration curriculum. In that role, he was involved in the development of Oracle9i and Oracle Database 10g. In March 2004, he decided to go independent and founded Natural Join B.V. (http://www.naturaljoin.nl). From 1999 until his passing in 2006, he was involved in the ISO SQL language standardization process, as a member of the Dutch national body. He was also one of the founding members of the OakTable network (http://www.oaktable.net).