Re: replace a substring in a table
Posted by:
dirk
Date: June 20, 2005 09:12AM
Felix, thanks for the reply. The problem though is ,
I need to scroll through my entire table to replace
all occurnces, not just one single row. Can I use
a sub-query ? i.e.
SELECT * FROM MYTABLE
WHERE (SELECT REPLACE('MyColumn'', '(0)','')...
;
TIA
Dirk
Subject
Written By
Posted
Re: replace a substring in a table
June 20, 2005 09:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.