|
Manuscripts
for
Hands-On Oracle Installation
Hands-On
01-Introduction
1(Important notes to remember)
Learn about the important notes to
remember when you do Oracle installation. The Oracle database and Developer
are very easy to install. The only difficulty that you may face is: How to establish
connectivity between the Oracle developer tools and the Oracle database on the same machine such as
windows98. - Manuscript
Hands-On
02-Basic
Introduction
Understanding of the basic
definition of elements, fields, and items, columns, records, and rows, tables, datatypes, primary
keys and foreign keys.
- Manuscript
Hands-On
03-Installation
and connectivity (TEXT)
Learn
how
to establish a connection from Developer to Oracle Database Personal Edition. - Manuscript
Hands-On
04-Installation
and connectivity
The Oracle database and Developer
are very easy to install. The only difficulty that you may face is: How to establish
connectivity between the Oracle developer tools and the Oracle database on the same machine such as
windows98. Learn how to make this connectivity. - Manuscript
Hands-On
05-De-installation-Remove Oracle (TEXT)
How
to remove all Oracle products, Oracle services,
and Oracle registry entries from your computer. - Manuscript
Hands-On
06-Create
"iself" user
Learn how to run the
script to create a user named "iself" with password "schooling" and all its
tables. - Manuscript
Manuscripts
for Hands-On SQL
Hands-On 01(SQL)
Learn
how to select
data from Oracle -
Manuscript
Hands-On 02(SQL)
Learn
how to select data from Oracle using advanced
data selection in Oracle - Manuscript
Hands-On 03(SQL)
Learn
how to create, drop, and maintain Oracle Database objects
- Manuscript
Hands-On 04(SQL)
Learn more how to create, drop, and
maintain other Database Objects in
Oracle - Manuscript
Hands-On
05(PL/SQL)
Learn
how to use command line editor which it is native to SQL*PLUS. - Manuscript
Hands-On
06(PL/SQL)
Learn how Oracle makes provisions
for you to utilize your favorite text editor to edit the statement created in "afiedt.buf,"
the file into which SQL*PLUS stores the most recently executed SQL statement.
- Manuscript
Manuscripts
for
Hands-On PL/SQL
I
Hands-On 01(PL/SQL)
Learn how to use command line editor
which it is native to SQL*PLUS. - Manuscript
Hands-On 02(PL/SQL)
Learn how Oracle makes provisions
for you to utilize your favorite text editor to edit the statement created in "afiedt.buf,"
the file into which SQL*PLUS stores the most recently executed SQL statement.
- Manuscript
Hands-On 03(PL/SQL)
Learn the basic fundamentals of
PL/SQL block. - Manuscript
Hands-On 04(PL/SQL)-Explicit
Cursor Handling
Learn how to declare a cursor to
list the department name (dname), total number of employees (ttemp), total salary (ttsal), and
average salary (avsal) for each department from the department table and employee table.
- Manuscript
Hands-On 05(PL/SQL)-Controlling
Process Flow
Learn how to modify the previous
PL/SQL block to use the "FOR LOOP" statement vs simple "LOOP."
- Manuscript
Hands-On 06(PL/SQL)-Populating
table using PL/SQL
Learn how to create a table with a
primary key constraint and then populate the table. -
Manuscript
Hands-On 07(PL/SQL)-Cursor
Parameter
Learn how to use the
“test_for_loop2” file from the previous Hands-On. Then modify the PL/SQL block that the
cursor only calculate the department statistics for a specific department. For example the
department number 10. -
Manuscript
Hands-On 08(PL/SQL)-How
to use EXECPTION
Learn how to modify the
“test_for_loop3” file from previous Hands-On. You need to add exception to the PL/SQL
block. - |