Oracle Database 11g SQL

by Jason Price

Write powerful SQL statements and PL/SQL programs

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

Explore SQL Plus and SQL DeveloperUse SQL SELECT, INSERT, UPDATE, and DELETE statementsWrite PL/SQL programsCreate tables, sequences, indexes, views, and triggersWrite advanced queries containing complex analytical functionsCreate database objects and collections to handle abstract dataUse large objects to handle multimedia files containing music and moviesWrite Java programs to access an Oracle Database using JDBCTune your SQL statements to make them execute fasterExplore the XML capabilities of the Oracle DatabaseMaster the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

Genres: Reference

943 pages, Kindle Edition

First published November 1, 2007

About the author

There is more than one author with this name

Reviews

[Amy · Rating 4 out of 5]

Excellent book and testing software. I did all the excercises and sample tests and it helped me earn an 82% score on the exam. Seems to be the best teaching-text out there for explaining the concepts behind working with Oracle 11g SQL.

[John Chilton · Rating 3 out of 5]

I am using it as a reference to fill on some holes left by other books covering similar topics, but what I have read seems entirely competent.

[Emil Petkov · Rating 5 out of 5]

Nice, clear reading. Also good for reference.

[Shoumadip Das · Rating 5 out of 5]

good