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..

Answer / kunal

use sign() with decode()

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.

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;

Answer / ajaz ahmad kumhar

SELECT SUM(COL_NAME) FROM
( SELECT COL_NAME FROM TABLE_NAME
ORDER BY COL_NAME DESC)
WHERE ROWNUM<=4;

Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?

1 Answers  

Is it possible to split the printpreviewer into more than one region?

1 Answers  

What is new_form built-in?

1 Answers  

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

0 Answers  

based on parameter value layout of report should change

1 Answers  

If a break order is set on a column would it effect columns which are under the column?

1 Answers  

What is Post-Block?

1 Answers  

Name the different triggers supported by oracle reports and their firing order.

0 Answers  

What is a property clause?

1 Answers  

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

0 Answers  

How can I sum column wise in Oracle excel report?

1 Answers  

What is bind reference and how can it carate?

1 Answers