Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Using Date Mask on ET Make No Rows Returned
Hi all,
I'm trying to use external table in Oracle 9i. One of my field is in date datatype, so I use date mask to create the external tables, it works ok, no error but when I select the table it return no rows. Below is my script :
CREATE TABLE EXT_TABLES
(
A VARCHAR2(50 BYTE) , B NUMBER , C VARCHAR2(7 BYTE) , D VARCHAR2(10 BYTE), E VARCHAR2(20 BYTE), F DATE, )
TYPE ORACLE_LOADER DEFAULT DIRECTORY EXT_TABLES ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ',' MISSING FIELD VALUES ARE NULL ( A , B , C , D , E , F DATE "DD/MM/YYYY" ) ) LOCATION ('data.csv')
Regards,
Resant Received on Mon Jun 05 2006 - 23:33:55 CDT