Beginning Oracle SQL

✍ Scribed by Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey (auth.)

• Publisher: Apress
• Year: 2014
• Tongue: English
• Leaves: 429
• Edition: 3
• Category: Library

✦ Synopsis

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries.

Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table.

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-xxv
Relational Database Systems and Oracle....Pages 1-22
Introduction to SQL and SQL Developer....Pages 23-58
Data Definition, Part I....Pages 59-68
Retrieval: The Basics....Pages 69-100
Retrieval: Functions....Pages 101-128
Data Manipulation....Pages 129-146
Data Definition, Part II....Pages 147-176
Retrieval: Multiple Tables and Aggregation....Pages 177-212
Retrieval: Some Advanced Features....Pages 213-244
Views....Pages 245-266
SQL*Plus Basics and Scripting....Pages 267-322
Object-Relational Features....Pages 323-340
The Seven Case Tables....Pages 341-350
Answers to the Exercises....Pages 351-394
Back Matter....Pages 395-410

✦ Subjects

Computer Science, general