Oracle Database 12c SQL

Oracle Database 12c SQL

<p><b>Write Powerful SQL Statements and PL/SQL Programs</b></p> <p>Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. <i>Oracle Database 12c SQL</i> 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.</p> <ul> <li>Use SQL statements to access an Oracle database</li> <li>Work with SQL*Plus and SQL Developer</li> <li>Write PL/SQL programs</li> <li>Create tables, sequences, indexes, views, and triggers</li> <li>Design advanced queries containing complex calculations</li> <li>Create database objects to handle abstract data</li> <li>Use date, time stamp, and time interval data types</li> <li>Establish user roles and privileges</li> <li>Handle multimedia files using large objects</li> <li>Tune SQL statements to make them execute faster</li> <li>Generate, process, and store XML data</li> <li>Master the very latest Oracle Database 12<i>c</i> features</li> </ul> <p>Code examples in the book are available for download.</p>