Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*LOADER using "TAB" Delimination?
Hi,
Look at sample .ctl file to load TAB delimited data:
LOAD DATA
INFILE 'grid.txt'
INTO TABLE grid
INSERT
FIELDS TERMINATED BY X'09' TRAILING NULLCOLS
(GRIDID,
DESCRIPT,
NUMROWS,
NUMCOLS
)
-- Best regards, Dmitry www.ispirer.com/products - Database migration tool for IBM DB2, Oracle and MS SQL. "Upanesh Patel" <upanesh_info_at_yahoo.com> wrote in message news:49cf532fcf283853164a5d78068b76ea.26770_at_mygate.mailgate.org...Received on Thu Nov 15 2001 - 03:43:31 CST
> hey gang -
>
> If I have a "TAB" delimited data file what criteria do I give in the
> terminated by "?"
>
> thanks,
>
> UP
>
>
> --
> Posted from hoproxy.proxy.lucent.com [192.11.226.120]
> via Mailgate.ORG Server - http://www.Mailgate.ORG