Re: Reading From Text File

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/04/14
Message-ID: <33526279.DCBC5E5D@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 CDT