top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is a Lexical Parameter in Oracle Report6i?

+3 votes
416 views
What is a Lexical Parameter in Oracle Report6i?
posted Feb 4, 2016 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Lexical parameter

These are used to replace a value dynamically at run time. 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 (&)

answer Feb 5, 2016 by Manikandan J
...