SQL Interview Question | What is the difference between Translate and Replace

In this video, we discuss the difference between Translate and Replace functions in SQL.

Check out the complete list of SQL Query Interview Questions -

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[pradeepba]

Please do some vidoes on regexp like(regexp_substr, regexp_replace, regexp_instr, regexp_like)

[sivakumar-wbpr]

Hi Madam, Are taking Erwin data model training also?

[rameshv]

Could you provide a vedio of real time works will done a developer
Couse experiance interview purpose

[rick]

On a footnote SQL400 has had translate for about 20 years.

[sreemanthkumar]

Ma'am Could you please teach ORACLE PLSQL CONCEPTS PLEASE

[dixitmca]

take example like- select replace('3*[2+1]/{8-4}', '[]', '()');

SELECT TRANSLATE('3*[2+1]/{8-4}', '[]{}', '()()');

[sreesailampavankalyan]

Please help me in this query
I have a column like
ABCD
EFGHI
JKL
MNOP
QRSTUV
WXYZ

and the Output be like
AC
EGI
JL
MO
QSU
WY