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;

.fmb will be in which folder

2 Answers  

At what point of report execution is the before Report trigger fired?

1 Answers  

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 Answers  

How can we call a URL from a menu (Oracle Forms 6i)?

2 Answers  

What is an OLE?

1 Answers  

Can you attach an lov to a field at design time?

1 Answers  

What is the content view and stacked view?

2 Answers  

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 Answers  

What are the different types of key triggers ?

1 Answers  

if some data is not transfered where it will get stored

0 Answers  

In what situation u create the BPA.

0 Answers   Zensar,

Give built-in routine related to a record groups?

1 Answers