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


Please Help Members By Posting Answers For Below Questions

What do we mean by record group in oracle forms?

838


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

2657


Explain the different levels at which oracle form services interact.

806


What is the difference between flex mode and confined mode?

746


how to send file attachment from oracle forms

2319


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1281


Explain the various types of oracle report?

829


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1780


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2074


why the Ctl file u put only in bin folder why not in other folder

1830


Explain master-detail relationship with some examples.

772


all steps of bitmap report?

2108


List the different types of columns in oracle reports.

782


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

1820


how do u compile a form i.e .fmb file in Unix or in dos

4359