| RAJNISH |
Posted: Aug 30, 2008 07:17:59 AM |
Total Post: 92
Joined: Jan, 2007
|
hi ALL,
can anyone tell me,
what diff between CASE WHEN and DECODE Function.?
because the purpose is same.
both r working as a if-then-else condition.
--Rajnish
|
|
|
seema |
| Posted: Sep 01, 2008 12:23:34 AM | |
|
Total Post: 70
Joined: Jan, 2008
|
Decode and case both are use for same work but the difference is in decode we are not using when and then keyword.syntax difference is there.
|
|
|
|
|
chai |
| Posted: Sep 01, 2008 01:09:38 AM | |
|
Total Post: 117
Joined: Jul, 2008
|
Case works faster than Decode.
|
|
|
|
|
seema |
| Posted: Sep 02, 2008 12:25:44 AM | |
|
Total Post: 70
Joined: Jan, 2008
|
why case is faster then decode?????????
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |