iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

More Resources by Google:

INDEX

Articles (only)

 

Case Studies (only)

 

SQL-PL/SQL (only)

Oracle9i SQL New Features (only)

DBA (only)

Developer (only)

 

Important Notes to remember (only)

Basic Introduction to JAVA (only)

 

LINUX and UNIX notes that DBAs must know (only)

 

Articles from an individual like you! (only)

 

 

SQL-PL/SQL

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.  -