SELECT CASE :ss
WHEN '1' THEN'one'
WHEN '2' THEN 'two'
ELSE 'default'
END CASE
, 'Example of Case Statement'
FROM DUAL
Friday, May 16, 2008
Example of Case Statement
Labels:
Sqlplus Tricks
Subscribe to:
Post Comments (Atom)
SELECT CASE :ss
WHEN '1' THEN'one'
WHEN '2' THEN 'two'
ELSE 'default'
END CASE
, 'Example of Case Statement'
FROM DUAL
During my work, sometimes I come across some information that I am sure to forget in a given time period. So I started this blog to post such information for future use. If it is of any use to you, please let me know.
No comments:
Post a Comment