Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Does anyone know how to import a tab delimited file.

Does anyone know how to import a tab delimited file.

From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Thu, 16 Dec 1999 21:24:06 GMT
Message-ID: <38595931.1AC6EEA9@lds.com>


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)

, 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)
Received on Thu Dec 16 1999 - 15:24:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US