Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

img4.png Click     Data Load Unload    ( cascade pictured )

img4.png Click Load

 

img4.png Click Load Spreadsheet Data

 

img4.png Select NeTable under "Load To"     and select Upload file from "Load From" CLICK NEXT

img4.png Browse and select the .csv file and CLICK NEXT

img4.png Type          "ACCOUNT-HEAD-MASTER"

 

against table name prompt and click NEXT

 

img4.png Select "Create New Column" under Primary Key From, Type "REC-ID" against New Primary key column, Leave the default PK constraint name, select "Generate From New Sequence" from Primary key population and type REC_ID_SEQ against sequenc and CLICK  "LOAD DATA"

You created the table successfully. Congrats. Now we shall play with created accounts_head_master table and understand some of the sql statements behavior.