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;

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

0 Answers  

How many pages you can in a single form ?

1 Answers  

Can a repeating frame be careated without a data group as a base?

2 Answers  

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

0 Answers  

what u write in Ctl file

2 Answers  

What is the built-in function used for finding the alert?

1 Answers  

What is bind reference and how can it carate?

1 Answers  

can i write commit in Before report trigger

4 Answers  

What built-in is used for changing the properties of the window dynamically?

1 Answers  

How many windows in a form can have console?

1 Answers  

What are the different window events activated at runtimes?

1 Answers  

what are the different objects that you cannot copy or reference in object groups?

1 Answers