Hi,
Could you please someone tell me the difference between the case statements and case expressions?. So far, I was under impression that both are synonymous. The following lines from
case expressions and statements in oracle 9i
" Most developers seem to use this term when they are in fact describing CASE expressions. The CASE statement is a PL/SQL-only construct that is similar to IF-THEN-ELSE. Its simple and searched formats are as follows."
claims that case statement is only PL/SQL construct. However, Oracle documentation uses both the terms in SQL as well as PL/SQL guide.
Reference:
Case statement in PL/SQL : CASE Statement
Case expressions in PL/SQL :Fundamentals of the PL/SQL Language
I got confused after reading the documentation.
Experts -What's your comments on this? Thanks for your time.