Case vs Decode in oracle sql plsql Lab Session 1

Case vs Decode in oracle sql plsql Lab Session 1

https://drive.google.com/file/d/1gwt2...

Below mention points are explained with the help of sql and plsql statements.

Decode and case statements in an oracle work or acts like if then elsif conditional statements.

Case can do every activity or tasks as like DECODE
Case includes all the features of Decode

In the below mention query, predicate with in is used for an employee post category and searchable subqueries are used with the exist clause in common bracket.

Case can be used in expression in plsql and sql whereas decode can be used in the sql as function.
Decode is called as the function because it can take input in the form of open and closed () brackets.

Case can work as the parameter to the procedure call whereas Decode cannot work as the parameter to the procedure call.
Searched Case work like Decode.