What is lexical parameter ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

i am writing a query select EmpNo from Emp how can i call in after parameter form

1608


how do u place it in required folder

1482


In what situation u create the BPA.

1779


Can we invoke one form from another in a multi-forms application?

645


what exactly u write in when_new_form_instance

2904






What is the difference between flex mode and confined mode?

534


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

633


How can we expand Parameter Form Canvas on Reports 6i?

1968


Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1701


What is the difference between BPA AND Contract What are documents and test cases u followed

1953


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

820


What are the various configuration files that are used by oracle forms?

579


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

1101


What is a canvas in oracle forms?

600


why the Ctl file u put only in bin folder why not in other folder

1604