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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You do not need to quote the whole post each time you answer.

Regards
Michel

Report message to a moderator

Previous Topic: Denormalization
Next Topic: query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 14:06:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.