Can anyone tell me what is the difference between case and decode. and which one is more

CASE executes faster.

DECODE works with expressions which are scalar values.

CASE can work with predicates and subqueries in searchable form:

CASE handles NULL values differently

Member Avatar


Decode MUST be in a Select statement and will not work using directly as PL/SQL.

A Case statement can be used directly in PL/SQL.

Note: Case is an old statement that was dropped,
BUT was brought back, so check your versions of DB.