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
- 7975 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is the difference between flex mode and confined mode?
all steps of bitmap report?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
what are the oracle forms services components include?
Name the different triggers supported by oracle reports and their firing order.
What is a matrix report and how many minimum groups are required to prepare the same?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
difference between global n context sensitive segments?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
from where do u receive the information to develop report
Name the different triggers associated with oracle forms having a master-detail relationship.
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 ?
