How can you create Lexical parameter n Bind parameter in
Reports ?
Answer Posted / swarna.alizerla
we can create lexical parameter & bind parameter in the
report in the data model query.
The bind parameter is used as well and lexical parameter
used for ex:
select &deptno,ename,deptno from emp where empno=:empno
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
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
how do u compile a form i.e .fmb file in Unix or in dos
What is the difference between flex mode and confined mode?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
a text item is there what r the different types of triggers associated with it
List the different types of columns in oracle reports.
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
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What are the various configuration files that are used by oracle forms?
What is the difference between bind and lexical parameter?
How to create Drill down report?
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
Can we invoke one form from another in a multi-forms application?
Is it possible to have multiple layouts in a report?
what is difference between group above and group left report