Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / kunal

use sign() with decode()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle report?

1071


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1982


What is the difference between flex mode and confined mode?

1049


if u want to delete all these detail block etc what will happen in form

1987


what is difference between group above and group left report

3820


Explain the various types of oracle report?

1075


What do you understand by oracle forms and why are they required?

1019


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

2135


What do you understand by oracle forms?

1041


what is tripstop report?

1835


What is the difference between BPA AND Contract What are documents and test cases u followed

2379


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1906


how report can be generated if we have the database designed in oracle 10g?

1888


Why oracle forms required?

1041


What do you understand by lov?

1037