everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

9i New Features


 

Manuscripts for Oracle9i and Developer 6i New Features

 

Create the ORACLE schema

Learn how to run the script to create a user named "oracle" with password "learning" and all its tables. Manuscript


Introduction 01 ("Must to know" Oracle9i: SQL New Features)

Learn the new Oracle ANSI SQL standard statement and compare it with the original non-ANSI Oracle SQL. - Manuscript


Introduction 02 ("A Must to know" Oracle9i: SQL 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

     Reviews and Templates for FrontPage
     

Copyright © everythingOracle.bizhat.com 2006 All Rights Reserved.