SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

replace vs translate

Oracle_MonkeyMar 5 2013 — edited Mar 5 2013

select REPLACE('ROOM','R','') FROM DUAL 

REPLACE('ROOM','R','')
OOM

select TRANSLATE('Rahul','R','') FROM DUAL 
TRANSLATE('ROOM','R','')
(null)

why i am getting null with translate AND y not 'OOM' ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2013

Added on Mar 5 2013

5 comments

1,157 views