Re: IMPORT DATA FROM TXT FILE

Mytskidis Georgios wrote:
> ??
>
> I've developed a small application named Text2Oracle which makes what you're
> asking for :
> 1).It takes as source a text file
> 2).You define the delimeter which distinguishes the text values
> 3). You connect to Oracle and select the destination-target table (provided
> that you've already created it).
> 4). You select which columns of the pre-selected oracle table will be used
> and for those columns you assign for every one the input data. These data
> may be a spesific "colon of the source text file", a value from an oracle
> sequence or a standard fixed value (which you provide)
> 5). The final step is for the application to translate the data and your
> settings to Oracle INSERT commands and execute the provided script. If any
> error occurs then the application points to the error and automatically
> rollsback.
>
> If you're interested send me an e-mail (no charge of course !!)

And exactly what does your "application" do that isn't done without any application using external tables?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)