Beginning Oracle SQL

✍ Scribed by Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton (auth.), Jonathan Gennick, Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes, Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Mat Wade, Tom Welsh, Jim Markham, Seth Kline (eds.)

• Publisher: Apress
• Year: 2010
• Tongue: English
• Leaves: 441
• Edition: 1
• Category: Library

✦ Synopsis

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

✦ Table of Contents

Front Matter....Pages i-xxiii
Relational Database Systems and Oracle....Pages 1-24
Introduction to SQL, SQLPlus, 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

✦ Subjects

Computer Science, general; Database Management