Shulou(Shulou.com)06/01 Report--

Oracle sqlldr imports a date column instance in detail

1.

LOAD DATAINFILE * INTO TABLE testFIELDS TERMINATED BY X'9'TRAILING NULLCOLS (c2 "upper (: c2)", c3 date "yyyymmdd", C1 "SEQ_test_c1.nextval") BEGINDATAAAAAAAAAAA 20051201BBBBBBBBBB 20050112CREATE TABLE TEST (C1 VARCHAR2 (10 BYTE), C2 VARCHAR2 (20 BYTE), C3 DATE); CREATE SEQUENCE VV_USER.SEQ_TEST_C1START WITH 0MAXVALUE 9999999MINVALUE 0NOCYCLENOCACHENOORDER

Sqlldr user/passwd control = load_date.ctl

Thank you for reading, hope to help you, thank you for your support to this site!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.