Oracle Database 11g SQL (Oracle Press)

Oracle Database 11g SQL (Oracle Press)

<p><b>Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, <span style="white-space:pre"></span>authenticity, or access to any online entitlements included with the product.</b></p><p><strong><br></strong></p><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>