What is translate in oracle?
- 1 Answers
- 1194 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
How translate command is different from replace?
How to find out what privileges a user currently has in oracle?
What is a nested table and how is it different from a normal table?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
how to clone 9i Database on to 10g Database.
What are the common oracle dba tasks?
How to define an anonymous procedure without variables?
What is logical backup in oracle?
what is IDE,DMV in sql server?
sql query to get zero records from a table
how to find full database size
1 Answers BirlaSoft, Consultancy,
Oracle General 
