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

from where do u receive the information to develop report

1964


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1100


i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2954


Explain master-detail relationship with some examples.

953


Explain the various types of oracle report?

1026


What is the difference between bind and lexical parameter?

1019


What is the difference between flex mode and confined mode?

996


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 ?

4559


how do u compile a form i.e .fmb file in Unix or in dos

4516


what are the new features introduced in oracle form services in 11g release 2?

983


all steps of bitmap report?

2306


i am writing a query select EmpNo from Emp how can i call in after parameter form

2056


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

956


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

2925


what are bind variables?

1021