Re: Update from Tab Delimited Text File

Tim Marshall wrote:
>
> HI folks, basic question, I think.
>
> I'm wondering if there is SQL I can use in SQL Plus that will update an
> existing Oracle table from a tab delimited text file. I'm actually doing
> this in an Access app that has some linked Oracle tables, but I do any
> updating using pass-through queries (an Access term I believe, for using
> Oracle SQL instead of MS Access SQL).
>
> I could do this easily using row processing (ie, DAO, going through each
> line in the text file and running a separate Oracle update query) but I
> would prefer to do set processing, ie, one update type query referring to
> the text file.
>
> Oracle server version is 8.05.
>
> Thanksvery much in advance for any guidance.
>
> --
> Tim - http://www.ucs.mun.ca/~tmarshal/
> ^o<
> /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
> /^^ "DittoooOOO?" - Ditto

Consider using PERL and its database module DBI. Should be a short easy script to write. (care to outsource it? I could do it.)

Ed Prochak Received on Mon Dec 09 2002 - 12:41:42 CST