Re: Import from text file
From: Barry <barryw_at_databaseanswers.com>
Date: 5 Jun 2003 10:51:33 -0700
Message-ID: <55816d8a.0306050951.1328a842_at_posting.google.com>
Date: 5 Jun 2003 10:51:33 -0700
Message-ID: <55816d8a.0306050951.1328a842_at_posting.google.com>
"Ned" <73613.3133_at_compuserve.com> wrote in message news:<bbl6bp$go4$1_at_ngspool-d02.news.aol.com>...
>Is it possible to read data from my pc drive in a PL/SQL program?
> How would I do this?
You could also use the new 9i feature of External Tables.
This allows you to handle spreadsheets (and I guess CSV files) as Tables.
Then you load data using only SQL :-
INSERT INTO table_name
SELECT *
FROM external_table_name
Barry Williams
Principal Consultant
Database Answers
Received on Thu Jun 05 2003 - 19:51:33 CEST