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

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2364


why the Ctl file u put only in bin folder why not in other folder

2096


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.

2278


What do you understand by lov and how can it be used?

1150


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

2059


Why oracle forms required?

1093


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

2024


What is an oracle report? List its various types.

1018


in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2959


What is an SQL FORMS ?

2831


Name the different triggers supported by oracle reports and their firing order.

1136


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

3088


Explain master-detail relationship with some examples.

1052


what is the difference between call_form, new_form and open_form?

1379


How to create Drill down report?

2185