Help Section
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
Help Section
The following reading and articles are important preparation for this lab. Please make sure you read them and understand the concepts and techniques in them.
- External Tables Article
- External Tables with Preprocessing
- External Tables Tutorial
SELECTstatementCREATEstatementINSERTstatement
