Oracle Database 10g SQL

With this book, you will

• Master standard SQL, as well as the extensions developed by Oracle Corporation for use with the specific features of the Oracle database.

• Explore PL/SQL (Procedural Language/SQL), which is built on top of SQL and enables you to write programs that contain SQL statements.

• Use SQL*Plus to execute SQL statements, scripts, and reports; SQL*Plus is a tool that allows you to interact with the database.

• Execute queries, inserts, updates, and deletes against a database.

• Create database tables, sequences, indexes, views, and users.

• Perform transactions containing multiple SQL statements.

• Define database object types and create object tables to handle advanced data.

• Use large objects to store up to 128 terabytes of character and binary data, and pointers to external files.

• Perform complex calculations using analytic functions.

• Use all the very latest Oracle10g features, such as the BINARY_FLOAT and BINARY_DOUBLE types, the MODEL clause, and the extensions to large objects and collections.

• Learn about database security.

• Implement high-performance tuning techniques to make your SQL statements really fly.

• Learn the basics of running SQL using Java through JDBC.

This book contains 16 chapters and one appendix.