Friday, May 30, 2008

External Tables - Oracle 10.2E

Note: We have to create PRODUCTS directory and data.csv file should be avaible in the PRODUCTS directory
CREATE TABLE "PRODUCTDATA"."PRODUCTS"
(
"COL1" NUMBER(19,0),
"COL2" CLOB,
"COL3" VARCHAR2(25 BYTE),
"COL4" VARCHAR2(10 BYTE),

)
ORGANIZATION EXTERNAL
(

TYPE ORACLE_LOADER
DEFAULT DIRECTORY "PRODUCT"
ACCESS PARAMETERS
(

records delimited by newline
fields terminated by ','
missing field values are null

)
LOCATION
(

'data.csv'

)

);

No comments:

iPhone Launch Screen Sizes

iPhone Portrait iOS 8 Retina HT 5.5 = 1242 X 2208 Retna HD 4.7 = 750 X 1134 iPhone Landscape iOS 8 Retina HD 5.5  2208 X 1242 iPho...