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

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

1091


if u want to delete all these detail block etc what will happen in form

1473


List out the oracle forms configuration files?

564


List the different types of columns in oracle reports.

570


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

2278






Explain the various types of oracle report?

546


how to send file attachment from oracle forms

2139


what is the difference between call_form, new_form and open_form?

720


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

631


What do we mean by record group in oracle forms?

614


what is tripstop report?

1354


Explain the different levels at which oracle form services interact.

606


difference between global n context sensitive segments?

2208


What is a matrix report and how many minimum groups are required to prepare the same?

551


what exactly u write in when_new_form_instance

2900