Need Help

[sahdev]

Hello
Everybody
I am planning to attend the Exam for OCP DBA on oracle 10g ..do you people have any sample Questions ?
you can mail me at sahdevchand@yahoo.com

Thank you

[purnarao80]

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