Re: Update from Tab Delimited Text File

Tim Marshall <tmarshal_at_morgan.ucs.mun.ca> wrote in message news:<Pine.OSF.3.95.1021208193842.12713B-100000_at_plato.ucs.mun.ca>...
> 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.

For version 8.0.5 look up sqlldr in the utilities manual. This utility is Oracle means of loading flat files into the Oracle rdbms. When you get to version 9 look up external tables.

HTH -- Mark D Powell -- Received on Mon Dec 09 2002 - 08:14:14 CST