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 -> Re: Does anyone know how to import a tab delimited file.

Re: Does anyone know how to import a tab delimited file.

From: support email <msftmail_at_us.oracle.com>
Date: Fri, 17 Dec 1999 17:08:52 GMT
Message-ID: <385a6dd8.2395210720@newshost.us.oracle.com>


LOAD DATA
INFILE 'mytabdata.txt'
TRUNCATE
INTO TABLE mytabtable
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS
.
.
.
Received on Fri Dec 17 1999 - 11:08:52 CST

Original text of this message

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