ENGLISH

Beginning Oracle SQL

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

Book information

Publisher
Apress
Year
2010
ISBN
9781430271970, 9781430271963
Language
english
Format
PDF
Filesize
4 MB (4297821 bytes)
Edition
1
Pages
459\441
Time added
2020-08-30 06:11:09
Computer Sciencegeneral; Database Management

Description

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 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

Similar books