Oracle sqlldr导入一个日期列实例详解

LOADDATA

INFILE *

INTOTABLEtest

FIELDS TERMINATEDBYXƏ'

TRAILING NULLCOLS

(

 c2"upper(:c2)",

 c3date"yyyymmdd",

 c1"SEQ_test_c1.nextval"

)

BEGINDATA

AAAAAAAAAA 20051201

BBBBBBBBBB 20050112

CREATETABLETEST

(

 C1 VARCHAR2(10 BYTE),

 C2 VARCHAR2(20 BYTE),

 C3DATE

);

CREATESEQUENCEVV_USER.SEQ_TEST_C1

STARTWITH0

MAXVALUE 9999999

MINVALUE 0

NOCYCLE

NOCACHE

NOORDER;