In this video the case statement is explained in detail with example using sql developer tool.
List of videos link is below
01 Topics to be covered and DB introduction
https://youtu.be/TP-CJ_wFyUo
02 Datatypes in Oracle SQL
https://youtu.be/lyxhpRaN8ow
03 Data retrieval , sorting and Restriction
https://youtu.be/uwV6LQbO6Lk
03 Data retrieval , sorting and Restriction continued
https://youtu.be/V3N7Y7w-0fI
04 Distinct and Unique Keys
https://youtu.be/huPHg3QiLio
05 Character Functions in Single Row Function
https://youtu.be/f8q-08QjOe4
06 Number Functions - Single Row Functions
https://youtu.be/GgEHwk7n-Ak
07 Date Functions - Single Row Function
https://youtu.be/ZvIaxIyeN6s
08 Conversion Function - Single Row Function
https://youtu.be/xT5vU6rU7Dw
09 NVL Functions
https://youtu.be/zBIUWL6VOgo
10 Case Statement - Conditional Expression
https://youtu.be/Y0nmkBaYvrw
11 Decode Function - Conditional Expressions
https://youtu.be/mag4zVmQUfc
12 Group Functions - Introduction
https://youtu.be/ZvxyA7dbWmk
13 AVG & COUNT - Group functions
https://youtu.be/dsoD6jQcB4Q
14 MIN,MAX & SUM - Group Functions
https://youtu.be/ooOwSF9-CK0
15 LISTAGG Group/Analytic/Special Function
https://youtu.be/aDSdGGH8lng