Re: Open ASCII file and create sql statements

bevscott_at_pps.k12.or.us wrote:
>
> I need to write a program that reads an ASCII file and then creates a sql
> statement from the data in the ASCII file. The sql will be used to pull data
> from a Oracle 7.2 database. I can use VB4 or Delphi 2. Should I be using
> PL/SQL statements to read the file.
>
> Does anybody have any suggestions.
>
> Thanks
> Bev Scott

Oracle's Procedure Builder has some read ascii functions accessible to PL/SQL. OR
You can use an OS batch language to build sqlplus statements for a series of inserts.
OR
Use your OS language to build an sqlloader statements that correspond to the ascii file.

If the file will remain in fixed format then the sqlloader control file is not hard to write.

-- 
Ed Kulis          408-341-5561        Hal Computer Systems
Sr. Oracle DBA    ekulis_at_hal.com      Campbell, CA 95008