|
Developers
Build
your schema to work on iSelfSchooling's Hands-On
In order
to practice the iSelfSchooling's case studies, you need to create a
user named iself with all its necessary tables. There is a script
named "create_tables.sql." If you want you can click here
to download the script on to your c:\ directory. Then sign on to
system/manager user and run the script. ex: SQL> start
c:\create_tables.sql
This
script will create a user named "iself" with password
"schooling" and all its tables. Don't forget that after
downloading any file from anywhere, virus check the file. Good
luck with your setup. --iSelfSchooling.com
SELF-How to Build your "ISELF" Schema
ISELF Schema
Script here
Hands-On Oracle Training
FORMS
FRM001-Introduction to complete Hands-On 01 to 06
FRM002-Dasic Intro about FORM Builder Tool
FRM003-(Hands-On 01) How to use Tab Canvas, Master-detail relationship
FRM004-(Hands-On 02) How to use Tooltip, Hint, Format Mask, Properties
FRM005-(Hands-On 03) How to use LOVs and Record Group
FRM006-(Hands-On 04) How to use Radio Buttons
FRM007-(Hands-On 05) How to use Display items, Summary and function columns
FRM008-(Hands-On 06) How to use FORMS Triggers (POST-QUERY)
FRM009-Introduction to complete Hands-On 07 to 12
FRM010-(Hands-On 07) How to use Horizontal Toolbar, Push Button, Trigger (WHEN-BUTTON-PRESSED)
FRM011-(Hands-On 08) How to do sizing and layout appearances
FRM012-(Hands-On 09) How to use Trigger (PRE-QUERY) and set dynamically properties
FRM013-(Hands-On 10) How to use Sequence object and Trigger (PRE-INSERT)
FRM014-(Hands-On 11) How to use Call FORM
FRM015-(Hands-On 12) How to use Global Variable and Trigger (WHEN-NEW-FORM-INSTANCE)
FRM016-Introduction to complete Hands-On 13 to 16
FRM017-(Hands-On 13) How to use Main Menu
FRM018-(Hands-On 14) How to use Pop up menu
FRM019-(Hands-On 15) How to move objects and manage the layout appearances
FRM020-(Hands-On 16) How to run application from desktop
FRM021-Inserting employee's picture to a table
FRM022-Viewing a picture using BLOB datatype in a FORM
FRM023-What is a REF CURSOR
FRM024-FORM BLOCK and TRANSACTIONAL TRIGGERS |
Hands-On Oracle Training REPORTS
|
RPT001-Introduction to complete Hands-On 01 to 06
RPT002-(Hands-On 01) How to write a Tabular report
RPT003-(Hands-On 02) How to write a Group left report
RPT004-(Hands-On 03) How to write a Mailing Label report
RPT005-(Hands-On 04) How to write a Matrix report
RPT006-(Hands-On 05) How to write a Form Letter
RPT007-(Hands-On 06) How to use Group Above
RPT008-Introduction to complete Hands-On 07 to 11
RPT009-(Hands-On 07) How to create and use Customized Template
RPT010-(Hands-On 08) How to use layout appearances (Boilerplate)
RPT011-(Hands-On 09) How to use Parameters
RPT012-(Hands-On 10) How to use Drill Down or Push Button report
RPT013-(Hands-On 11) How to use LOVs (List Of Values) |
|