DECODE FUNCTION IN SQL

Published: 27 November 2022
on channel: TECH MASTER JAGA 🤓

DECODE FUNCTION IN SQL #DECODEFUNCTIONINSQL #SQL #SQLFORBEGINNER

DECODE FUNCTION IS USED TO DECODE THE DATA FROM ONE FORMAT TO ANOTHER.
LET SEE ONE EXAMPLE

GUJ-- GUJARAT
BNG--BENGALORE
BELGM--BELGAUM

FOR THIS WE HAVE TO DECODE QUERY BELOW

SELECT DECODE(LOC,'GUJ','GUJARAT','BNG','BENGALORE','BELGM','BEGAUM',LOC) AS UPDATE_LOC FROM TRAVEL;

DECODED SUCCESSFULLY
---------------------------------------------------------------------------------------------------------------------------
USES OF RANK AND DENSE_RANK FUNCTIONS IN SQL #SQL #RANKFUNCTIONS #DENSE_RANK #SQLBEGINNER.
   • USES OF RANK AND DENSE_RANK FUNCTIONS IN S...

HOW TO EXTRACT NAMES FROM EMAIL ID BY "SUBSTR FUNCTION" ||SUBSTR FUNCTION|| SQL #SQL #SUBSTRFUNCTION
   • HOW TO EXTRACT NAMES FROM EMAIL ID BY "SUB...

#SUBSTR
#sql
#LEARN SQL
EXTRACT NAMES,DOMAIN NAME,SERVICE PROVIDER NAME FROM SUBSTR FUNCTION.
#ORACLE DATABASE

SQL DDL COMMAND #SQL #LEARNSQL #ddl
   • SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUN...

SQL DML COMMAND #SQL #LEARNSQL #DML
   • SQL DML COMMANDS #SQL #DMLCOMMANDS #INSERT...

SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUNCTIONS #learnsql
   • SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUN...
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

THANK YOU FOR WATCHING
PLEASE DO SUBSCRIBE FOR MORE UPDATES!!!

On this page of the site you can watch the video online DECODE FUNCTION IN SQL with a duration of hours minute second in good quality, which was uploaded by the user TECH MASTER JAGA 🤓 27 November 2022, share the link with friends and acquaintances, this video has already been watched 31 times on youtube and it was liked by 0 viewers. Enjoy your viewing!

1,283