After creating the database tables our next move is to interactively add some seed data to these tables. This task will also be performed via wizards and built-in features of Oracle APEX.
Execute the following steps to first upload data to the DEMO_CUSTOMERS table.
1. From the main Oracle APEX menu, select SQL Workshop | Utilities | Data Workshop.
2. On the Get Started page, click
the Load Data button.
3. On the next screen, click the Choose
File button. In the Open dialog box, select DEMO_CUSTOMERS CSV file and open it. The CSV file is available in the SourceCode\Part2
folder.
4. The Load Data page will appear on your screen. Select
options on this screen as illustrated in the following figure. By selecting the
Existing Table option you are
informing that you want to upload the CSV file data to the existing
DEMO_CUSTOMERS table that you need to select from the provided Table list. Once
you select the database table, Oracle APEX will automatically map the columns. Click
the Load Data button on this page. A
message "Data in
table DEMO_CUSTOMERS appended with 7 new rows!"
should appear on your screen. Click the View
Table button to browse the data.
5. Repeat steps 1 through 4 to upload data to the remaining tables in the
following sequence using their appropriate CSV files: DEMO_STATES,
DEMO_PRODUCT_INFO, DEMO_ORDERS, and DEMO_ORDER_ITEMS.
