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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*LOADER using "TAB" Delimination?

Re: SQL*LOADER using "TAB" Delimination?

From: Dmitry <support_at_ispirer.com>
Date: Thu, 15 Nov 2001 11:43:31 +0200
Message-ID: <9t02mg$15k5g1$1@ID-75577.news.dfncis.de>


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...

> 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
Received on Thu Nov 15 2001 - 03:43:31 CST

Original text of this message

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