i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my q

Categories >> Software >> Databases >> Oracle >> Oracle Forms Reports
Suggest New Category

i have 9 values in a table i.e

-99
-56
-32
41
-2
33
95
-88
55

my question is that i wanna elimenate all -ve values and
wann sum of + values in report

i m using devsuite 10g

its urgent

kindly if anyone knows that answer message me the following
yahoo id

thanx

ALI
smalipaki@yahoo.com

Question Posted / ali

5 Answers
7863 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wa..

Answer / debmalya gupta

select sum(column_name) into l_return from table_name
where column_name >=0

paste this in a formula column and make it the source of
sum amount..

Is This Answer Correct ?

8 Yes

1 No

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wa..

Answer / kunal

use sign() with decode()

Is This Answer Correct ?

1 Yes

0 No

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wa..

Answer / girdhari bawane

Hi,
See, Suppouse there is table 'test' in database and having
columns col1 number. this table holding records as
COL1
=====
1
-2
-3
3
-4
4
-5
5
-6
6
2
write query as-
SELECT SUM(col1) FROM test WHERE col1>0;
Result := 21.

Is This Answer Correct ?

1 Yes

0 No

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wa..

Answer / ajaz ahmad

TRIGGER:- when button_pressed

declare
cursor c1 is select colum-name from table-name;
sum table-name%rowtype;
begin
sum := 0;

for z in c1 loop
if z.column-name < 0 then
null;
else
sum := NVL( sum + nvl(z.column-name),0);
end if;
end loop;
message('Sum of +ve Values is ='|| sum);
end;