Home » SQL & PL/SQL » SQL & PL/SQL » Help with this code (10g)
Help with this code [message #391811] Fri, 13 March 2009 12:26 Go to next message
natasha87
Messages: 1
Registered: March 2009
Junior Member
Hello everyone

I am trying to write a package where i am extensively using CASE and DECODE statements but i am getting confused with the statements. Can someone demonstrate an example or point to good resources for the same.

Thanks and Regards
Natasha Smile
Re: Help with this code [message #391813 is a reply to message #391811] Fri, 13 March 2009 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In SQL:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions040.htm#i1017437
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions004.htm#i1033392

In PL/SQL:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/fundamentals.htm#sthref518
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/controlstructures.htm#i8305

Regards
Michel
Re: Help with this code [message #391827 is a reply to message #391811] Fri, 13 March 2009 14:43 Go to previous messageGo to next message
haivj
Messages: 1
Registered: March 2009
Junior Member
Hi,

Please post the code what you tried until now.

Thanks
Re: Help with this code [message #391874 is a reply to message #391811] Sat, 14 March 2009 02:53 Go to previous messageGo to next message
vaibhavk
Messages: 7
Registered: March 2009
Junior Member
natasha87 wrote on Fri, 13 March 2009 12:26
Hello everyone

I am trying to write a package where i am extensively using CASE and DECODE statements but i am getting confused with the statements. Can someone demonstrate an example or point to good resources for the same.

Thanks and Regards
Natasha Smile

Help with this code? where is the code?

Like Michel pointed out there are tons of documentation on CASE and decode. Here's one excellent article with practical examples on sql decode and case.
Re: Help with this code [message #391886 is a reply to message #391874] Sat, 14 March 2009 03:50 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You do not need to quote the whole post each time you answer.

Regards
Michel
Previous Topic: Denormalization
Next Topic: query
Goto Forum:
  


Current Time: Sun Dec 11 08:15:49 CST 2016

Total time taken to generate the page: 0.04103 seconds