Case And Decode Function In Oracle SQL (IF THEN ELSE) With Examples | CASE DECODE FUNCTIONS

Case And Decode Function In Oracle SQL (IF THEN ELSE) With Examples | CASE DECODE FUNCTIONS IN ORACLE SQL

About this Video?!
------------------------------------------
Hi Guys! Today we will learn Conditional Expressions in Oracle SQL Programming, there are two types of Conditional Expressions are as follows:
1. CASE EXPRESSION
2. DECODE FUNCTION
So watch full video because you wouldn't be able to understand if you will not Watch till the end.

And if you like this video then don't forget to LIKE and SUBSCRIBE my Channel for more informative videos including Tips and Tricks.

#sql #sqltutorialforbeginners #shahzadacademy

Previous Lecture - 26: NVL, NVL2, NULLIF and COALESCE FUNCTIONS: https://youtu.be/c13dWNm_SdQ

___________/LINKS\________________
► Facebook:➜ https://www.facebook.com/groups/shahzadacademy
► Twitter:➜ https://twitter.com/Shahzad_Academy
► Instagram:➜ https://www.instagram.com/shahzad_khan_wardak

****** Step By Step SQL Programming Course ******
Lecture-1: SQL Tutorial for Beginners: https://youtu.be/7EogAhIVxiE
Lecture-2: Spool File & Single / Multi lines Comments in SQL: https://youtu.be/HlGpAsKj4L4
Lecture-3: Editing in Login file in SQL: https://youtu.be/E3FW42A_fCU
Lecture-4: How to Use iSQL Plus: https://youtu.be/FATnI9nsLM0
Lecture-5: How to Use Where Clause in SQL: https://youtu.be/1AWt1rDdKlQ
Lecture-6: How to Use Order BY Clause: https://youtu.be/8ZQVKy2_34E
Lecture-7: How to Use Arithmetic Operators in SQL: https://youtu.be/Y-qR63cQrYA
Lecture-8: How to Use CONCAT - LITERAL and Q-Operator in SQL: https://youtu.be/hTGGTWjDdIw
Lecture-9: Using DISTINCT in SQL | Column Formatting: https://youtu.be/fOMI-qz-sxI
Lecture-10: How to Save Query in SQL and RUN | Clear Buffer Command: https://youtu.be/F4pP7pq4oZ4
Lecture-11: AND / OR Condition in SQL: https://youtu.be/ZLO2gMToQaA
Lecture-12: BETWEEN Operator in SQL: https://youtu.be/fqqcDsZhmgI
Lecture-13: How to Use IN and NOT IN Operators | DESCRIBE table in SQL : https://youtu.be/oGhWf7HhHsc
Lecture-14: Substitution Variables in SQL: https://youtu.be/hQS8ffW7HiQ
Lecture-15: How to Use LIKE Operator in SQL: https://youtu.be/7BXsNucwP04
Lecture-16: UPPER | LOWER | INITCAP Functions & DUAL Table In Oracle: https://youtu.be/nmWGrBnbGko
Lecture-17: CONCAT & SUBSTR Functions: https://youtu.be/vqnFFfEGt8k
Lecture-18: INSTR & LENGTH Functions: https://youtu.be/A5FZsxZFJyk
Lecture-19: LPAD | RPAD | TRIM & REPLACE Functions: https://youtu.be/VmnLzTDuzYE
Lecture-20: SQL Numeric Functions ROUND TRUNC MOD: https://youtu.be/8KNXDk0PKAE
Lecture-21: Working with SysDate | ALTER SESSION SET NLS_DATE_FORMAT Command: https://youtu.be/9wfb6NBDs1s
Lecture-22: Using Arithmetic Operators with Dates: https://youtu.be/mPIds0iPuTY
Lecture-23: DateTime functions in SQL: https://youtu.be/VYO-07rD3JU
Lecture-24: Conversion Functions TO_DATE | TO_CHAR | TO_NUMBER: https://youtu.be/TYMywKEMPPw
Lecture-25: Nesting Functions Within Functions: https://youtu.be/nL08n3Uytr8

****** Windows & Database Installations Video Tutorial ******
Oracle SQL developer 19.4 on Windows 10 64 bit: https://youtu.be/ttUBrgu7Zi0
Oracle 11g Installation in windows 10 64bit: https://youtu.be/NmqLFILApuI
Oracle 10g Installation in windows 10 64bit: https://youtu.be/onmcACoD_6Y
Oracle 10g Installation in Windows 7 64bit: https://youtu.be/5g_yzfpdjSQ
Oracle 10g Installation in Windows Xp 32bit: https://youtu.be/gDvBqMJboOk
Windows 7 Installation in VMware: https://youtu.be/xNvuRdpj_wY
Windows XP Installation in VMWare: https://youtu.be/f1w6qycQpiE

****** Make Resume / CV Full Video Tutorials ******
Make Resume/CV in Microsoft Word: https://youtu.be/Y-6mnTn1mxE
Make Resume/CV Online Method: https://youtu.be/NfTeZ5ePO40

****** Microsoft Office Tips & Tricks Full Video Tutorials ******
MS-EXCEL: How to Make Calculator in Excel Using VBA: https://youtu.be/lioV0AWO9Jc
MS-OUTLOOK: How to Connect Gmail Account with Outlook: https://youtu.be/_8_jRUcapkM
MS-WORD: How to Create CV in Microsoft Word: https://youtu.be/Y-6mnTn1mxE

****** Others Video Tutorials *******
How to Secure Google Account from Hackers: https://youtu.be/z7x-logI-N0
How To Create A Free Website & Free Domain & Hosting: https://youtu.be/3BY6bbm5Jko
Free HD BSR Screen Recorder for PC: https://youtu.be/0uUTBYVnEeA
Free HD APowersoft Screen Recorder for PC: https://youtu.be/HY8wjlSPsJ0

For any Query (Please feel free to contact me):
-----------------------------------------------------------------------------
G-mail id : [email protected]

***Thanks For Watching My Channel SHAHZAD ACADEMY***