Manuscripts
for Oracle9i
and Developer 6i New Features
Create
the ISELF schema
Learn how to run the script to create a
user named "iself" with password "schooling" 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 iselfschooling’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