In this example, you load data into the
PURCHASE_ORDERS table that you created in "Example: Creating a Table". For simplicity, this example loads only three rows.
To prepare for this example, you must create a text file named
load.csv on the file system of the database host computer or on the file system of your local computer. The contents of the file should be as follows:
1,Office Equipment,25-MAY-2012,1201,13-JUN-2012 2,Computer System,18-JUN-2012,1201,27-JUN-2012 3,Travel Expense,26-JUN-2012,1340,11-JUL-2012
This example assumes that the columns in the
PURCHASE_ORDERS table are the following:
PO_DATE_RECEIVED. If your
PURCHASE_ORDERS table does not have all these columns (or has additional columns), then modify the data in the text file accordingly.
To load data into the PURCHASE_ORDERS table:
PURCHASE_ORDERStable in the HR schema, following the instructions in "Viewing Tables".
PURCHASE_ORDERStable and select Import Data.
The Open dialog box appears.
load.csvfile that includes the data you want to import into the table, and then click Open.
The Data Import Wizard appears, with the Data Preview page displayed.
csv, Line Terminator is set to
environment default, and that Left Enclosure and Right Enclosure are set to
none. Then click Next.
The Import Method page appears.
Insert in the Import Method field.
PURCHASE_ORDERS in the Table Name field.
A value in the Import Row Limit field that is greater than the number of rows in your
The Choose Columns page appears.
The Column Definition page appears.
.csvfile to the existing table. For each source data column on the left, select the column on the right to import this data into.
For example, in the Source Data Columns table on the left, select the first column, and then in the Target Table Columns table on the right, select in the Name field the name of the column in the database table that will store that data. Map the data for each of the columns in the Source Data Columns table to the appropriate column in the Target Table Columns table.
PO_DATE_RECEIVED) in the Target Table Columns table. At this point, the previous four columns in the Source Table Columns table have already been mapped to the appropriate columns in the Target Table Columns table.
The Finish page appears.
The data is imported into the table.
" About Tables"