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.
The following steps will create some sample tables which will be used by the APEX application for the upload screen:
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...