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

When to use Place holder columns in Oracle Reports and what is a place holder column?

Could u tell me, u work as a support & maintenace when sub ledger and gl is mismatch, then how do u match with the both side/

Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?

List the different types of columns in oracle reports.

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

what are the new features introduced in oracle form services in 11g release 2?

What is the use of image_zoom built-in?

How do you reference a Parameter?

Can a field be used in a report wihtout it appearing in any data group?

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

Can you mention lexical parameter in select statement in the data model?

List system variables available in forms 4.0, and not available in forms ?

For more Oracle Forms Reports Interview Questions Click Here