Skip to main content

Difference Between CASE and DECODE?

– CASE is a expression

 – DECODE is a function
- CASE expression is ANSI SQL Statement

- DECODE is specific to Oracle Syntax


- CASE syntax contains WHEN and THEN 

- DECODE will not have this


- CASE allow expressions or Scalar Sub query Expressions inside the CASE statement

- DECODE won't allow expressions inside the DECODE function

Comments

Post a Comment

Popular posts from this blog

Oracle Reports - Changing the current mode (Confine or Flex)

To set or override Confine mode:  In the Paper Layout view, click  Confine On or Confine Off  in the toolbar to toggle the mode: On: child objects cannot be moved outside their enclosing parent objects. Off: child objects can be moved outside their enclosing parent objects. To set or override Flex mode:  In the Paper Layout view, click  Flex On or  Flex Off in the toolbar to toggle the mode: On: parent borders "stretch" when child objects are moved against them. The child object maintains the same distance from the side it moves against. Off: parent borders remain fixed when child objects are moved against them.
Post a Comment
Read more