Re: Reading From Text File
From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/04/14
Message-ID: <33526279.DCBC5E5D_at_pmcgettigan.demon.co.uk>#1/1
Date: 1997/04/14
Message-ID: <33526279.DCBC5E5D_at_pmcgettigan.demon.co.uk>#1/1
Mark McCubbin wrote:
> I'm writing an application that obtains data from flat ascii text
> file
> and adds to Oracle database. What is the best way to do this?
>
> Thanks...
>
> Papiya
Try sqlloader, PL/SQL (latest versions can read/write OS files) or any of the Oracle programmatic interfaces - Pro*C, etc. For non-Oracle solutions, try loading through Access, Excel (via ODBC) or Powerbuilder, SQLWindows (vi their native database interfaces). Oh, and there are about 1,000,000 'data migration' products out there if your needs become much greater.
Steve Phelan. Received on Mon Apr 14 1997 - 00:00:00 CEST