Creating your application tables

Application tables will contain the information that is required for the data warehouse solution, but cannot be obtained from any existing source system. The APEX application will provide a means to capture this information and store it within the application tables.

Getting ready

Log in to your database schema created in the previous recipe.

How to do it...

The following steps will create some sample tables which will be used by the APEX application for the upload screen:

1. 1. The table we will use is a simple customer table, defined as follows:

   CREATE TABLE "APP_CUSTOMER"
   (
   "CUST_SEQ" NUMBER NOT NULL ENABLE,
   "CUST_NUM" VARCHAR2(50 BYTE) NOT NULL ENABLE,
   "CUST_NAME" VARCHAR2(50 BYTE),
   "CUST_ADDRESS1" VARCHAR2(50 BYTE),
   "CUST_ADDRESS2" VARCHAR2(50 BYTE),
   "CUST_CITY" VARCHAR2(50 BYTE),
   "CUST_PCODE_ZIP" VARCHAR2(20 BYTE),
   "CUST_STATE" VARCHAR2(50 BYTE),
   "CUST_COUNTRY" VARCHAR2(50 BYTE),
   "REGION" VARCHAR2(50 BYTE),
   "CREATE_DATE" DATE,
   "CREATE_BY" VARCHAR2(50 BYTE...