Database Reference
In-Depth Information
, COUNTRY_ID
NUMBER
, LIST_PRICE
FLOAT
, DISCOUNT
FLOAT
, SALE_PRICE
FLOAT
, SALE_DATE
DATE
, SALE_QTY
NUMBER
, SHIPPING_COST
FLOAT)
ORGANIZATION EXTERNAL
(
DEFAULT DIRECTORY data
ACCESS PARAMETERS
(
FIELDS TERMINATED BY ","
(
SALES_ID
INTEGER EXTERNAL(5)
, MUSICCD_ID
INTEGER EXTERNAL(5)
, CUSTOMER_ID
INTEGER EXTERNAL(5)
, RETAILER_ID
INTEGER EXTERNAL(5)
, CONTINENT_ID
INTEGER EXTERNAL(5)
, COUNTRY_ID
INTEGER EXTERNAL(5)
, LIST_PRICE
FLOAT EXTERNAL
, DISCOUNT
FLOAT EXTERNAL
, SALE_PRICE
FLOAT EXTERNAL
, SALE_DATE
DATE "DD-MON-YY"
, SALE_QTY
INTEGER EXTERNAL(5)
, SHIPPING_COST
FLOAT EXTERNAL
)
)
LOCATION ('salesext.txt')
)
REJECT LIMIT UNLIMITED;
Note:
Access parameter field definitions require INTEGER datatypes to be
declared as an EXTERNAL(n) datatype, not EXTERNAL as for
SQL*Loader. There are no strings in the SALES table, but all strings would
have to be represented as CHAR(n) fixed-length strings, n representing a
maximum length.
Executing another query would give the same result as that shown in
Figure 18.12.
