how can create the lexical parameter after the select class?
Answer Posted / ashutosh
just create a parameter
and write sql command in report like this...
select * from emp
where &condition
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What do you understand by oracle forms?
What is responsibility and how u attach How to create user and how u attach with responsibility.
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
How can we expand Parameter Form Canvas on Reports 6i?
what is difference between group above and group left report
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
how do u compile a form i.e .fmb file in Unix or in dos
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
Can we invoke one form from another in a multi-forms application?
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
what is tripstop report?
List the different types of columns in oracle reports.
In what sequence do triggers get fired by oracle forms?
how report can be generated if we have the database designed in oracle 10g?
if some data is not transfered where it will get stored