Description
Lab #9: External Tables
Learn how to create an externally managed table and how to run anonymous block PL/SQL programs to fix data states in the some of the tables. You create the airport
and account_list
tables and their respective airport_s1
and account_list_s1
sequences before running the anonymous block PLSQL programs. You also insert six rows into the common_lookup
table.
- Lab
- Description
- Help Section
- Instructions
Lab Description
You learn how to import a flat-file through an externals.
The lab has four parts, which you find after clicking on the Lab Instructions link. The steps are:
- Step 1: Create an internally managed
transaction
table. - Step 2: Insert rows into the
common_lookup
table for thetransaction_type
andpayment_method_type
of thetransaction
table. - Step 3: Create the internally managed
airport
andaccount_list
tables and populate them with data by calling an anonymous block PL/SQL program. - Step 4: Create the externally managed
transaction_upload
table and query it for results.