Thread: Need Help
View Single Post

  #2 (permalink)  
Old 08-02-2006, 03:30 AM
purnarao80 purnarao80 is offline
Junior Member
 
Join Date: May 2005
Posts: 3
purnarao80 is on a distinguished road
Hello Frds

I Have a problem with soving the string replacement using PL/SQL Functions.....it wil do by replace function, but with out using that we have to get solution My program is



select strreplace('This is a beautiful day!', 'beautiful', 'horrible')
from dual

The given query selects the string 'This is a horrible day!'. The string 'beautiful' is replaced by 'horrible'. Write the function strreplace.


pls give solution
Reply With Quote