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
Explain the different levels at which oracle form services interact.
Is it possible to execute a dynamic sql from forms?
if some data is not transfered where it will get stored
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What do you understand by lov?
What is an SQL FORMS ?
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
What do you understand by oracle forms?
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
In what situation u create the BPA.
What are the various configuration files that are used by oracle forms?
In what sequence do triggers get fired by oracle forms?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?