tag:blogger.com,1999:blog-1271763227002553835.post9204876804697220980..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: The Case for the Case StatementAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1271763227002553835.post-26927158373453099492013-09-09T09:01:44.217+02:002013-09-09T09:01:44.217+02:00This is awesome - thanks! Nice one here too on se...This is awesome - thanks! Nice one here too on searched case statements:<br /><br />http://www.programmerinterview.com/index.php/database-sql/sql-searched-case-expression/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-28654863448093857202013-02-13T12:19:01.607+01:002013-02-13T12:19:01.607+01:00Hello there! Have you ever been in such a situatio...Hello there! Have you ever been in such a situation when a person has stolen your personal ideas? Can't wait to hear from you.HurryUpToEnjoyLifehttp://hurryuptoenjoylife.wordpress.com/noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-91805518832290914082013-02-01T11:06:34.623+01:002013-02-01T11:06:34.623+01:00Amazing...!!Amazing...!!watislifehttps://www.blogger.com/profile/11400866797665985652noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-64672042528623932132010-01-18T10:10:26.501+01:002010-01-18T10:10:26.501+01:00Indeed, thank you for this addition.Indeed, thank you for this addition.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-37749812242784153532010-01-18T09:59:42.896+01:002010-01-18T09:59:42.896+01:00Please note that only case statements raise CASE_N...Please note that only case statements raise CASE_NOT_FOUND, case expressions return null:<br /><br />gDEV>r <br /> 1 declare<br /> 2 procedure test(<br /> 3 i_testcase in varchar2,<br /> 4 i_in in varchar2)<br /> 5 is<br /> 6 begin<br /> 7 dbms_output.put_line(<br /> 8 i_testcase||<br /> 9 ': '||<br /> 10 case i_in<br /> 11 when 'Y' then 'Yes!'<br /> 12 when 'N' then 'No...'<br /> 13 end);<br /> 14 end;<br /> 15 begin<br /> 16 test('Input Y', 'Y');<br /> 17 test('Input N', 'N');<br /> 18 test('Input Z', 'Z');<br /> 19* end;<br />Input Y: Yes!<br />Input N: No...<br />Input Z:<br /><br />PL/SQL-Prozedur erfolgreich abgeschlossen.Chrishttps://www.blogger.com/profile/00349422981782291908noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-65184899850817233752010-01-16T19:42:17.603+01:002010-01-16T19:42:17.603+01:00Your welcome. I guess you mean the ELSE clause of ...Your welcome. I guess you mean the ELSE clause of the CASE statement, WHEN OTHERS can only appear in an Exception Block.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-85732883261801998212010-01-16T18:25:54.472+01:002010-01-16T18:25:54.472+01:00Alex,
Thanks. I was not aware of CASE_NOT_FOUND e...Alex,<br /><br />Thanks. I was not aware of CASE_NOT_FOUND exception. I always use CASE...WHEN OTHERS THEN.Anonymousnoreply@blogger.com