External Table Example


CREATE TABLE "XX_STAGE_SUPPLIERS"
(
"SUPPLIER_NAME" VARCHAR2(200),
"SUPPLIER_NO" VARCHAR2(50)
)
ORGANIZATION external
(
TYPE oracle_loader
DEFAULT DIRECTORY XXBMASSINV
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
BADFILE ' XXBMASSINV':'VENDOR7.bad'
LOGFILE 'VENDOR7.log_xt'
READSIZE 1048576
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' LDRTRIM
REJECT ROWS WITH ALL NULL FIELDS
(
"SUPPLIER_NAME" CHAR(200)
TERMINATED BY "," OPTIONALLY ENCLOSED BY '"',
"SUPPLIER_NO" CHAR(255)

)
)
location
(
'table_export777.csv'
)
);



/*--Sample Data


"HOLCH POVLSEN SWITZERLAND AG","410025"
"ABS TRIKO TEKSTIL","253410"
"AKTIESELSKABET AF 21.11.2001","008067"
"AKTIESELSKABET AF DEN 17.11.2011","99423204"
"RIMAKS","253606"
"GULEKS TEKSTIL TIC. VE SAN. LTD. STI.","250063"
"BESTSELLER UNITED CHINA LTD.","111011"
"HAMARATLI DIS TICARET LTD. STI.","252606"
"VILA A/S","96274000"
"BS STUDIO CHINA LTD.","115656"
"GRANARIES LIMITED","111304"
"AKTIESELSKABET AF 4.10.2012.","99423200"
"Dasthagiri","120.00"
"Dilip","2000"

Comments

Popular posts from this blog

Oracle APPS Useful Queries

How to Apply Timers In Forms

Unix Shell Script For Oracle Apps