How translate command is different from replace?
- 1 Answers
- 1185 Views
- I also Faced
- E-Mail Answers
Answer / Syed Abdul Nadeem
The TRANSLATE function in Oracle is used to replace a specific character or a set of characters with another character or a set of characters throughout the string. On the other hand, REPLACE replaces only a specific character or set of characters within a specified position without considering the original case of the characters. In contrast, TRANSLATE considers the case-sensitive replacement.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Water Mark in Oracle?
How to get a create statement for an existing table?
What is different types of joins?
How to pass a parameter to a cursor in oracle?
Why should I use oracle database?
Can we store pictures in the database and if so, how it can be done?
Define the terms primary key foreign key and also the difference between primary and the unique key
How to write a left outer join with the where clause in oracle?
What are the set operators union, union all, minus & intersect meant to do?
What is the function of Optimizer ?
What is ASM (Automatic Storage Management) in Oracle?
What is flashback Query ? And Use ?
Oracle General 
