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

What package procedure used for invoke sql plus from sql forms ?

1 Answers  


What do you mean by a pop-up window ?

1 Answers  


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

0 Answers  


What is the built_in routine used to count the no of rows in a group?

1 Answers  


Is it possible to execute a dynamic sql from forms?

0 Answers  






What are the built_ins used the display the LOV?

1 Answers  


can my report have different layouts

2 Answers  


What is a radio Group?

1 Answers  


what is latest version in reports

3 Answers   KPIT, Wipro,


How do you trap the error in forms 3.0 ?

1 Answers  


How to create placeholder columns?

2 Answers  


Explain about stacked canvas views?

2 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)