What is the difference between Subquery and Corelated Subquery?Give some examples of each

What is the difference between Case and Decode?In what situation we can use Case and Decode

veerisetty

 Profile Answers by veerisetty Questions by veerisetty

• Jun 18th, 2008

DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode looks for a value.regardsveerisetty

Answer Question  Select Best Answer