| Neeraj |
Posted: Jul 03, 2008 12:50:07 AM |
Total Post: 258
Joined: Jan, 2007
|
hi,
i want to display 0 when i get negative number. how to do it ?
if i get -234 then shud be print 0.
thxs |
|
|
 positive |
| Posted: Jul 04, 2008 12:55:29 AM |  |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
You can try using a PL/SQL block.
select &var from dual;
var numb := var
if {}
/
|
|
|
|
|
| Murtuja |
| Posted: Jul 04, 2008 01:01:51 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Use case statement for this requirement
read more from below site
http://www.databasejournal.com/features/oracle/article.php/3344871
|
|
|
|
|
| muna |
| Posted: Jul 06, 2008 07:44:53 AM | |
|
Total Post: 14
Joined: Jul, 2007
|
you set condition with function sign()
|
|
|
|
|
| jai |
| Posted: Jul 14, 2008 02:24:30 AM | |
|
Total Post: 1
Joined: Jun, 2008
|
Select Decode(Sign(value),-1,0) from dual
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
