Interested to Buy Any Domain ? << Click Here >> for more details...
i have 9 values in a table i.e
-99
-56
-32
41
-2
33
95
-88
55
my question is that i wanna elimenate all -ve values and
wann sum of + values in report
i m using devsuite 10g
its urgent
kindly if anyone knows that answer message me the following
yahoo id
thanx
ALI
smalipaki@yahoo.com
- 5 Answers
- 7831 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
Explain master-detail relationship with some examples.
what are bind variables?
What do you understand by oracle forms and why are they required?
how report can be generated if we have the database designed in oracle 10g?
How to create Drill down report?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
Why oracle forms required?
what is oracle forms?
What do you understand by oracle forms?
List the different types of columns in oracle reports.
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
from where do u receive the information to develop report
