Home » SQL & PL/SQL » SQL & PL/SQL » sql help
sql help [message #225480] Tue, 20 March 2007 01:36 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
hi,

is there any diff decode and case.

is there any limitations in decode.

Thanks
srinivas
Re: sql help [message #225488 is a reply to message #225480] Tue, 20 March 2007 01:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
How often do we have to point you to the manuals??
Re: sql help [message #225501 is a reply to message #225488] Tue, 20 March 2007 02:37 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
<snip> twice in a week but not in a day, once in a year but twice in a decade </snip>

Re: sql help [message #225506 is a reply to message #225480] Tue, 20 March 2007 03:22 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
CASE will do anything that decode can do, and quite a bit more.
DECODE is more concise, but frequently harder to read.
Previous Topic: New Row in Table
Next Topic: INSERT UPDATE trigger HELP
Goto Forum:
  


Current Time: Sun Dec 04 19:01:23 CST 2016

Total time taken to generate the page: 0.07130 seconds