Replace and Translate in sql
This video demonstrates the difference between a replace function and a translate function in oracle using an suitable example. Both the function does a similar task, but has a lot of difference in implementation and output when used. Be learning the difference users can easy justify the correct scenarios on where to use translate and when to use replace.
If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below :
union and union all : • UNION AND UNION ALL SET OPERATOR IN O...
char and varchar2 : • DIFFERENCE BETWEEN CHAR AND VARCHAR2 ...
procedure and function : • Difference between Procedure and Func...
in and exists : • IN VS EXISTS VS JOIN, performance
rank and dense_rank : • Row Number, Rank and Dense Rank in sq...
delete and truncate : • Difference between Delete and Truncat...
%type and %rowtype : • type and rowtype PL/SQL | difference ...
Subscribe to the channel : / @kishanmashru
Other Playlists:
Data Warehousing Concepts: • Data Warehousing Concepts
Python and Database: • Python | How to Install python packages
SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVIEW QUESTIONS
SQL and PL/SQL concepts: • SQL and PLSQL
Content and video created by : Kishan Mashru
