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
What is an oracle report?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What is the difference between flex mode and confined mode?
if u want to delete all these detail block etc what will happen in form
what is difference between group above and group left report
Explain the various types of oracle report?
What do you understand by oracle forms and why are they required?
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?
what is tripstop report?
What is the difference between BPA AND Contract What are documents and test cases u followed
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
how report can be generated if we have the database designed in oracle 10g?
Why oracle forms required?
What do you understand by lov?