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

Click     Data Load I  Unload    ( cascade pictured )

Click Load

Click Load Spreadsheet Data

Select New  Table under "Load To"     and select Upload file from "Load From" CLICK NEXT

Browse and select the .csv file and CLICK NEXT

Type          "ACCOUNT-HEAD-MASTER"

against table name prompt and click NEXT

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