Answer Posted / Awadheshwar Kumar
TRANSLATE in Oracle is a string function that replaces one set of characters with another. It takes three arguments: the source string, the translation table, and the replacement string. An example would be:
```sql
SELECT TRANSLATE('ABCDEFG', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'XYZABCDEFGHIJKLMNOPQRSTUVW') AS translated_string FROM dual;
```
In this example, it replaces all uppercase letters A-Z in the string 'ABCDEFG' with their respective positions in the replacement string.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle latest version?
How to put more than 1000 values into an oracle in clause?
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
