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;