Database Tutorial

Course Tutorial Site

Site Admin

Description

without comments

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

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 the transaction_type and payment_method_type of the transaction table.
  • Step 3: Create the internally managed airport and account_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.

Written by michaelmclaughlin

August 13th, 2018 at 11:36 am

Posted in