Beginning Oracle SQL (Expert's Voice in Oracle)

__Beginning Oracle SQL__ is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic __Mastering Oracle SQL and SQL\*Plus__ by **Lex de Haan**, and has been updated to cover developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, __Beginning Oracle SQL__ is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database. * Takes an example-based approach, with clear and authoritative explanations * Introduces both SQL and the query tools used to execute SQL statements * Shows how to create tables, populate them with data, and then query that data to generate business results

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover developments in Oracle’s version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database.

• Takes an example-based approach, with clear and authoritative explanations
• Introduces both SQL and the query tools used to execute SQL statements
• Shows how to create tables, populate them with data, and then query that data to generate business results

What you’ll learn

• How to create database tables and define their relationships
• How to add data to your tables, then change and delete that data
• How to write database queries that generate accurate results
• How to avoid common traps and pitfalls in writing SQL queries
• How to take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more
• How to get a handle on Oracle database’s support for object types in the database

Who this book is for

This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.

Table of Contents

1. Relational Database Systems and Oracle
2. Introduction to SQL, AQL*Plus, and SQL Developer
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. Writing and Automating SQL*Plus Scripts
12. Object-Relational Features

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. *Takes an example-based approach, with clear and authoritative explanations *Introduces both SQL and the query tools used to execute SQL statements *Shows how to create tables, populate them with data, and then query that data to generate business resultsWhat you'll learn *Create database tables and define their relationships *Add data to your tables; change and delete that data *Write database queries that generate accurate results *Avoid common traps and pitfalls in writing SQL queries *Take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more *Get a handle on Oracle Database's support for object types in the databaseWho is this book for? This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed Front Matter....Pages i-xxiii Relational Database Systems and Oracle....Pages 1-24 Introduction to SQL, SQL*Plus, and SQL Developer....Pages 25-69 Data Definition, Part I....Pages 71-81 Retrieval: The Basics....Pages 83-116 Retrieval: Functions....Pages 117-144 Data Manipulation....Pages 145-161 Data Definition, Part II....Pages 163-193 Retrieval: Multiple Tables and Aggregation....Pages 195-232 Retrieval: Some Advanced Features....Pages 233-264 Views....Pages 265-286 Writing and Automating SQL *Plus Scripts....Pages 287-327 Object-Relational Features....Pages 329-347 Back Matter....Pages 349-423 This text is a revision of Lex de Haan's introductory book on SQL for Oracle developers and administrators. Newly updated to cover the latest Oracle features and syntax, it has been renamed "Beginning" to reflect its key position in Apress' Oracle lineup.