Oracle Database 12c SQL

by Jason Price

Write Powerful SQL Statements and PL/SQL Programs

Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This Oracle Press guide contains everything you need to know to master SQL.

Use SQL statements to access an Oracle databaseWork with SQL*Plus and SQL DeveloperWrite PL/SQL programsCreate tables, sequences, indexes, views, and triggersDesign advanced queries containing complex calculationsCreate database objects to handle abstract dataUse date, time stamp, and time interval data typesEstablish user roles and privilegesHandle multimedia files using large objectsTune SQL statements to make them execute fasterGenerate, process, and store XML dataMaster the very latest Oracle Database 12c featuresCode examples in the book are available for download.

Genres: Programming

688 pages, Kindle Edition

First published January 1, 2013

About the author

There is more than one author with this name

Reviews

[AbdAllah · Rating 4 out of 5]

Great for beginners.

[Przemek · Rating 4 out of 5]

Książka bardzo dobra. Taka w miarę obszerna dokumentacja. Polecam.

[Hhh · Rating 5 out of 5]

good