DECODE FUNCTION IN SQL

Опубликовано: 21 Май 2026
на канале: 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!!!