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;

What are the different modals of windows?

1 Answers  

With which function of summary item is the compute at options required?

1 Answers  

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

1 Answers  

What are the types of visual attribute settings?

1 Answers  

How do you create a new session while open a new form?

1 Answers  

What are the built_in used to trapping errors in forms 4?

1 Answers  

What is a library in Forms 4.0?

1 Answers  

What are Most Common types of Complex master-detail relationships?

1 Answers  

in before report trigger SRW.user_exit(FND_Userinit) what will do

3 Answers  

Use the add_group_column function to add a column to record group that was created at a design time?

2 Answers  

How image_items can be populate to field in forms 4.0?

1 Answers  

Why oracle forms required?

0 Answers