Hi,

Execute below query ...and let me have your feedback...

Select decode ( sign( nvl(a_number,0)) , 1 , 'GREATER ZERO' , -1 , 'LESS
THEN ZERO' , 0 , 'ZERO' ) from lazy_dba ;

Thanks,
Akash


-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x32316654.[Email address protected]
Sent: Thursday, June 28, 2007 2:32 PM
To: LazyDBA Discussion
Subject: RE: DECODE statenment

The DECODE statement still works in Oracle, but why not use the CASE
statement?





Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x62011161.[Email address protected]
Sent: Thursday, June 28, 2007 2:02 AM
To: LazyDBA Discussion
Subject: DECODE statenment

Dear Friends
How do i check in a sql decode statement whether a column value is less
than zero.


Regards
Shadab


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page