Re: Easy way to import comma-separated file

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Wed, 18 Jul 2001 10:15:07 +0400
Message-ID: <9j3971$hjb$1_at_news247.cnt.ru>


Hello!

Geoffrey Dufour <g.dufour_at_swing.be> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:3b544b4e$0$4567$ba620e4c_at_news.skynet.be...
> Thanks.
>
> Two questions :
>
> 1. Is it possible to handle Date format with SQL Loader ?

Yes it's possible.

>
> 2. Is it possible to handle flat files having multiple separator chars.
 Ex.
> : Separator = :;: instead if ; ?

It's possible too.

Yaroslav.

>
> Regards.
>
>
> "Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> a écrit dans le message news:
> 9j1guu$d9g$1_at_news247.cnt.ru...
> > SQLLDR, SQLLOAD - SQL Loader for Oracle
> >
> > Yaroslav.
> >
> >
> > Geoffrey Dufour <g.dufour_at_swing.be> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
> > ÓÌÅÄÕÀÝÅÅ:3b544306$0$4562$ba620e4c_at_news.skynet.be...
> > > Hello,
> > >
> > > What is SQLLDR ?
> > >
> > > "Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> a écrit dans le message
 news:
> > > 9j15i3$c23$1_at_news247.cnt.ru...
> > > > Hello!
> > > > SQLLDR is the best choice.
> > > >
> > > > Best regards!
> > > >
> > > > Yaroslav.
> > > >
> > > > Philipp Krapp <phkrapp_at_yahoo.de> ñîîáùèë â íîâîñòÿõ
> > > > ñëåäóþùåå:ab0d8b0d.0107170101.2337da24_at_posting.google.com...
> > > > > Hi,
> > > > >
> > > > > shortly we will use Oracle 8i Release 8.16 for NT.
> > > > >
> > > > > What will be the easiest way to import comma-separated files into
 a
> > > > > database? We have to import those files every 24 hours with the
> > > > > AT-Command (or WinAT-Command)
> > > > >
> > > > > I thank you in advance for your helpful answer!
> > > > >
> > > > > Philipp
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Wed Jul 18 2001 - 08:15:07 CEST

Original text of this message