how can create the lexical parameter after the select class?

Question Posted / vissu

how can create the lexical parameter after the select class?..

Answer / 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

More Oracle Forms Reports Interview Questions

Is it possible to attach same library to more than one form?

Explain the various types of oracle report?

what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

Explain the following file extention related to library?

What is the User-Named Editor?

Is it possible to disable the parameter from while running the report?

Is it possible to split the printpreviewer into more than one region?

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Name the two files that are created when you generate the form give the filex extension ?

How to create placeholder columns?

At what point of report execution is the before Report trigger fired?

What are the two types views available in the object navigator?

For more Oracle Forms Reports Interview Questions Click Here