3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by hfx642
0

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

Edited by debasisdas: n/a

0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.