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 built-ins that are used to Attach an LOV programmatically to an item?

1 Answers  

---

Explain about horizontal, Vertical tool bar canvas views?

1 Answers  

---

Name of the functions used to get/set canvas properties?

1 Answers  

---

List the windows event triggers available in Forms 4.0?

1 Answers  

---

WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?

1 Answers   TATA, TCS,

---

---

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

What is a library in Forms 4.0?

1 Answers  

---

A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

2 Answers  

---

can i send the control file path as a parameter

1 Answers  

---

I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent

0 Answers  

---

How can you create Lexical parameter n Bind parameter in Reports ?

1 Answers   GE, SVSS,

---

What is the advantage of the library?

2 Answers  

---