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

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
How often do we have to point you to the manuals??

Report message to a moderator

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: 21823
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>

Toggle Spoiler

Report message to a moderator

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.

Report message to a moderator

Previous Topic: New Row in Table
Next Topic: INSERT UPDATE trigger HELP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 21:14:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.