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
- 5 Answers
- 7964 Views
- I also Faced
- E-Mail Answers
Answer Posted / debmalya gupta
select sum(column_name) into l_return from table_name
where column_name >=0
paste this in a formula column and make it the source of
sum amount..
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Name the different triggers associated with oracle forms having a master-detail relationship.
What is an SQL FORMS ?
List out the oracle forms configuration files?
from where do u receive the information to develop report
what is tripstop report?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
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
what are bind variables?
Is it possible to have multiple layouts in a report?
How can we generate report output in excel format?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
how do u place it in required folder
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 ?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Is it possible to execute a dynamic sql from forms?
