ID INV_DATE ACCT_NO
--- ------------ --------------
701 03/15/09 CODDA009
702 03/17/09 CODDA010
703 03/18/09 CODDA011
01 CREATE TABLE INVOICES_EXTERNAL
02 ( INVOICE_ID CHAR(3),03 INVOICE_DATE CHAR(9),
04 ACCOUNT_NUMBER CHAR(13)
05 )
06 ORGANIZATION EXTERNAL
07 (TYPE ORACLE_LOADER
08 DEFAULT DIRECTORY INVOICE_FILES
09 ACCESS PARAMETERS
10 (RECORDS DELIMITED BY NEWLINE
11 SKIP 2
12 FIELDS (INVOICE_ID CHAR(3),
13 INVOICE_DATE CHAR(9),
14 ACCOUNT_NUMBER CHAR(13))
15 )
16 LOCATION ('INVOICE_DATA.TXT')
17 );
------Oracle Database SQL Expert Exam Guide --CertifiCation objeCtive 11.07
没有列的间隔设置,如何控制字段间隔呢?