Re: find/replace on long field

Hugh wrote:
> I have a table where I am searching for text in a long field to be
> replaced in Oracle 8.
>
>
>
> I have created something like
>
> update table_tbl
> set FIELD =
> replace(FIELD,'text_to_be_Replaced','new_text_to_be_inserted')
> where FIELD like '%'||'text_to_be_Replaced'||'%'
>
> but that does not work since you can not run an oracle function on a
> Long field. Since this database works with 3rd party software,
> changing the field to a CLOB is not a viable option.
>
>
> any recommendations?

In order of precedence
- get rid of the software. Oracle 8.0 was desupported in the previous milennium.
- put the updated records in a temporary table. Use the *sqlplus*!!! COPY command to replace the affected records. You will need to set up a database link to the database you are connected too.
the COPY statement is documented in the sqlplus reference manual.

-- 
Sybrand Bakker
Senior Oracle DBA