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
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
why the Ctl file u put only in bin folder why not in other folder
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.
What do you understand by lov and how can it be used?
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
Why oracle forms required?
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
What is an oracle report? List its various types.
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
What is an SQL FORMS ?
Name the different triggers supported by oracle reports and their firing order.
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
Explain master-detail relationship with some examples.
what is the difference between call_form, new_form and open_form?
How to create Drill down report?