| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: Replace and Translate
Answer: How and in what way REPLACE is different from TRANSLATE? |
| September 09, 2008 05:34:30 |
#3 |
| seenu333p |
Member Since: July 2008 Total Comments: 1 |
RE: Replace and Translate
|
Translate:
It is used to replace charecter by charecter
Ex:
Select translate('ashok','xp','sk')
from dual;
result: ashok
Replace:
It is used to replace word by word
Ex:
select replace('tech world','Tech','technology')
from dual;
result: technology world |
| |
Back To Question | |
