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: Importing Data From Flat Files

Re: Importing Data From Flat Files

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Sat, 22 Jan 2000 15:26:46 +0500
Message-ID: <86ophk$25pg$1@dolf.netfront.net>


How would you run it from a stored procedure?

regards,
M. Armaghan Saqib

+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL
| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/
+---------------------------------------------------------------
Stevie <steviep9_at_hotmail.com> wrote in message news:3887D224.FE3B6A4A_at_hotmail.com...
> You could also use SQLLoader
>
> "M. Armaghan Saqib" wrote:
>
> > You can using UTL_FILE but you will have to do all row parsing and
> > textfile-table column mapping yourself in your PLSQL code.
> >
> > regards,
> > M. Armaghan Saqib
> > ------------------------------------------------------------------------
> > * SQL PlusPlus: Add power to SQL Plus.
> > * SQL Link for XL: Integrate Oracle with XL.
> > * Oracle CBT with sample GL (Triggers and Forms Source Code included.
> > Download free: http://www.geocities.com/armaghan/
> > ------------------------------------------------------------------------
> >
> > In article <8631f5$vl0$1_at_aklobs.kc.net.nz>,
> > "Richard F" <raf@(deletethis).scl.co.nz> wrote:
> > > Can you import data into tables from flat files by executing a stored
> > > procedure?
> > >
> > > Thanks
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>


Posted via news://freenews.netfront.net Complaints to news_at_netfront.net Received on Sat Jan 22 2000 - 04:26:46 CST

Original text of this message

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