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
- 7837 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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..
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What do you understand by lov?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What is an SQL FORMS ?
why the Ctl file u put only in bin folder why not in other folder
what is tripstop report?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What do you understand by lov and how can it be used?
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
did u p prepared complex report
What do we mean by record group in oracle forms?
Name the different triggers associated with oracle forms having a master-detail relationship.
How can we expand Parameter Form Canvas on Reports 6i?
hiding item in report how like that properly,thats manually but at runtime i want to do
