Oracle Database 11g SQL

<p><strong>Write powerful SQL statements and PL/SQL programs</strong></p><p>Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert Jason Price. Published by Oracle Press <em>Oracle Database 11g SQL</em> 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.</p><ul><li><div>Explore SQL Plus and SQL Developer</div></li><li><div>Use SQL SELECT INSERT UPDATE and DELETE statements</div></li><li><div>Write PL/SQL programs</div></li><li><div>Create tables sequences indexes views and triggers</div></li><li><div>Write advanced queries containing complex analytical functions</div></li><li><div>Create database objects and collections to handle abstract data</div></li><li><div>Use large objects to handle multimedia files containing music and movies</div></li><li><div>Write Java programs to access an Oracle Database using JDBC</div></li><li><div>Tune your SQL statements to make them execute faster</div></li><li><div>Explore the XML capabilities of the Oracle Database</div></li><li><div>Master the very latest Oracle Database 11<em>g</em> features such as PIVOT and UNPIVOT flashback archives and much more</div></li></ul>