Case « PL SQL « Oracle PL / SQL






1.Simple case demo
2.Case conditions
3.Case with else
4.CASE WHEN statement with variable
5.CASE WHEN with constant
6.CASE not found while executing CASE statement
7.This CASE statement is labeled
8.CASE WHEN with comparison operator
9.Uses a NUMBER datatype as the selector








10.Output discount rate based on different category