Beginning Oracle® Application Express

2.3. Expanding Your Application

The basic "work" of creating an application framework and the first few pages is done. Now you can add more data and pages to the application. For the purposes of learning about APEX development while building this sample application, your next task will be to add a table with data related to the ORDERS table.

2.3.1. Importing Order Items

The ORDERS table contains information that pertains to the overall order. The ORDER_ITEMS table contains details about individual products ordered. It makes sense that the ORDER_ITEMS table would somehow be connected with the ORDERS table. In this section, you will import data for order lines, establish the connection to the ORDERS table, and see how APEX automatically incorporates that relationship into the default pages you can use to access both the master and detail tables.

Try It Out: Importing and Linking Another Table The order entry application that is the focus of this book requires more than one table. Now that you have imported the ORDERS table, performing the same operation for the ORDER_ITEMS table is simple. But once you create the table through the import process, you can then link the data in that table to related rows in the ORDERS table Go to the Utilities page, and then to the Load page under the Data Load/Unload icon. Select the Load Spreadsheet Data icon. Change the Load From: choice to Upload File, and click Next. Select the ORDER_ITEMS.csv as the source, and click Next. Give the new table the ...