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:
- 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), ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
