9i New Features

Learn more about some Oracle9i: SQL New Features such as the �MERGE� and  �WITH summary_name AS� statements. - Manuscript

Hands-On 01 (Materialized Views � The view that stores data)

Learn how to pre-compute database information into a summary data aggregated to be easily understood. Learn how to write simple SQL statement using the �ROLLUP� operator to create salary subtotals for each type of job per year. Also, you should use the CUBE operator to enable a simple statement to calculate all possible combinations of the types of jobs and year for the research department only. - Manuscript

Hands-On 02(The break on clause)

Learn how to write a simple report to create a control break on columns.  - Manuscript

Hands-On 03 (Troubleshooting � UNION, INTERSET, and MINUS statements)

Learn how to check the contents of a table with an another table. - Manuscript

Hands-On 04 (Troubleshooting Deleting duplicated records)

Learn how to eliminate records duplication from a table. - Manuscript

Hands-On 05 (Data Partitioning)

Learn how to partition a table and how to run a query against a partition segment. - Manuscript

Hands-On 06 (Data Warehousing � The ROLLUP and CUBE function)

Learn how to to write simple SQL statement using the �ROLLUP� operator to create salary subtotals for each type of job per year. Also, hot to use the CUBE operator to enable a simple statement to calculate all possible combinations of the types of jobs and year for the research department only.  - Manuscript 

Hands-On 07 (Using Native Dynamic SQL)

Learn how to write a stored procedure to pass the table name and get back the number of records that table contains. The SELECT statement must be created a dynamically, since you don�t know what table you are getting statistics from. You should write your function so that your client can display all of the tables� name, plus the number of records contained each table. - Manuscript

Hands-On 08  (JAVA Stream)

Learn how to write a simple java program to identify a special problem that can be classified by everythingoracle's problems only. - Manuscript

Hands-On 09 (Defining Objects and Collection Types)

Learn how to use the nested object tables for a table. Learn how to use the �CONSTRUCTOR� operator to refer to the nested table with the �THE� syntax.  - Manuscript

Hands-On 10 (Inserting employees� picture into the EMP table using BLOB / CLOB)

Learn how to add pictures into a table using a stored procedure  - Manuscript

Hands-On 11 (Viewing a picture using BLOB datatype)

Learn how to develop an application form to display all of the employee information plus their picture. - Manuscript

Hands-On 12 (What is a REF CURSOR)

Learn how to complete the process for basing a block on a stored procedure for �single block operations and create a package called "managers_pkg.".  - Manuscript

Hands-On 13 (FORM BLOCK and TRANSACTIONAL TRIGGERS)

Learn how to use the �managers_pkg� package from previous Hands-On that you created to insert, delete, update, lock, and count a record.  - Manuscript