Write powerful SQL statements & PL/SQL programs Learn to access Oracle databases through SQL statements & construct PL/SQL programs with guidance from Oracle expert Jason Price. Published by Oracle Press Oracle Database 11g SQL explains how to retrieve & modify database information use SQL Plus & SQL Developer work with database objects write PL/SQL programs & much more. Inside you'll find in-depth coverage of the very latest SQL features & tools performance optimization techniques advanced queries Java support & XML. This book contains everything you need to master SQL. Explore SQL Plus & SQL Developer Use SQL SELECT INSERT UPDATE & DELETE statements Write PL/SQL programs Create tables sequences indexes views & triggers Write advanced queries containing complex analytical functions Create database objects & collections to handle abstract data Use large objects to handle multimedia files containing music & movies Write Java programs to access an Oracle Database using JDBC Tune your SQL statements to make them execute faster Explore the XML capabilities of the Oracle Database Master the very latest Oracle Database 11g features such as PIVOT & UNPIVOT flashback archives & much more