What is lexical parameter ?

Answers were Sorted based on User's Feedback



What is lexical parameter ? ..

Answer / anil kumar karasi

Lexical parameter is a condition (where clause) given at
runtime to generate the report on that condition. The '&'
symbol will preceed the where clause condition.

Is This Answer Correct ?    13 Yes 0 No

What is lexical parameter ? ..

Answer / deepak muduli

Lexical parameters can dynamically replace clauses in the
Select statement in the data model and even the whole
select statement. It replaces any part of a SELECT
statement, such as column names, the FROM clause, the WHERE
clause, the ORDER BY clause. To create a lexical reference
in a query, prefix the parameter name with an ampersand (&)

Is This Answer Correct ?    8 Yes 3 No

Post New Answer

More Oracle Forms Reports Interview Questions

difference between repeating frame and frame

3 Answers   IBM,


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

1 Answers  


What is an user exit used for?

1 Answers  


How do you reference a Parameter?

1 Answers  


What is the difference between boiler plat images and image items?

1 Answers  






how can u store a picture file in oracle database? explain the path/command?

1 Answers   GE, Satyam,


What is a library in Forms 4.0?

1 Answers  


Can you change the alert messages at run-time?

2 Answers  


what is integrity n how many integrity rules r there?

2 Answers   Convergys,


I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.

1 Answers  


Does a Before form trigger fire when the parameter form is suppressed.

2 Answers  


What use of command line parameter cmd file?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)