Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Does anyone know how to import a tab delimited file.
I tries using '\t' as the terminator character but that did not work in
sun solarias.
INFILE 'data'
REPLACE
INTO TABLE IMP_LOCAL_DETAIl
FIELDS TERMINATED BY '\t'
TRAILING NULLCOLS
(
ACCOUNT_NUMBER char (20)Received on Thu Dec 16 1999 - 15:24:06 CST
, BILL_NUM char (20)
, CHARGE_NUM char (20)
, SERVICE char (20)
, CHARGE_DATE date (11)
, TIME char (20)
, NUMBER_CALLED char (20)
, CITY char (20)
, STATE char (20)
, CLS char (3)
, MINUTES decimal external
, COST decimal external
, SERVICE_TOTAL_MINUTES decimal external
, SERVICE_TOTAL_COST decimal external
, CHARGE_NUM_TOTAL_MINUTE decimal external
, CHARGE_NUM_TOTAL_COST decimal external
, BILL_NUM_TOTAL_MINUTES decimal external
, BILL_NUM_TOTAL_COST decimal external)
![]() |
![]() |