Re: Cursor: does the job but doesn't come back
Date: 1996/04/14
Message-ID: <4kr7ol$mpf_at_news.acns.nwu.edu>#1/1
In article <4kl7mi$rq3$1_at_perth.DIALix.oz.au>,
marknal_at_perth.DIALix.oz.au (Mark Brayshaw) wrote:
>I'm having an annoying problem with a cursor in SQL*plus.
>I have a table of about 42000 rows that I have just loaded using SQLLoader.
>One of the columns is a not_null containing the soundex of another column
>of the same table. For load purposes I fill this column with a constant,
>then I run a routine to loop through the table and update the column
>with the correct soundex'd value.
> I run the routine as anonymous block out of SQL*PLUS. I define the cursor
>as a select for update where the column contains the constant.
put the soundex function into the sqlload script and skip the update phase.
column_name "soundex(:other_column_name)", ...
-- Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.Received on Sun Apr 14 1996 - 00:00:00 CEST