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 / ajaz ahmad kumhar

SELECT SUM(COL_NAME) FROM
( SELECT COL_NAME FROM TABLE_NAME
ORDER BY COL_NAME DESC)
WHERE ROWNUM<=4;

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different levels at which oracle form services interact.

1061


Is it possible to execute a dynamic sql from forms?

1077


if some data is not transfered where it will get stored

1942


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1453


if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1898


What do you understand by lov?

1038


What is an SQL FORMS ?

2795


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

2138


What do you understand by oracle forms?

1047


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

3003


In what situation u create the BPA.

2211


What are the various configuration files that are used by oracle forms?

1034


In what sequence do triggers get fired by oracle forms?

966


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2288


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1303