Interested to Buy Any Domain ? << Click Here >> for more details...
what is lexical parameter?
- 3 Answers
- 19594 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajeshwar
with this u can specify a complete where condition for
example select * from emp where &lex_par; i.e we can
specify where conditions.with bind variables we give values
to columns in query .
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / samaresh
Lexical references are placeholders for columns or
parameters that you embed in a SELECT statement. You can
use lexical references to replace the clauses appearing
after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING,
CONNECT BY, and START WITH. Use a lexical reference when
you want to substitute multiple values at runtime. You
cannot make lexical references in a PL/SQL statement. You
can, however, use a bind reference in PL/SQL to set the
value of a parameter that is then referenced lexically in
SQL, as shown in te example below. You create a lexical
reference by typing an ampersand (&) followed immediately
by the column or parameter name. A default definition is
not provided for lexical references.
Therefore, you must do the following:
Before you create your query, define a column or parameter
in the data model for each lexical reference in the query.
For columns, you must set the Value if Null property, and,
for parameters, you must set the Initial Value property.
Restrictions::::
You cannot make lexical references in a PL/SQL statement.
If a column or parameter is used as a lexical reference in
a query, its data type must be character.
If you want to use lexical references in your SELECT
clause, you should create a separate lexical reference for
each column you will substitute. In addition, you should
assign an alias to each lexical reference. This enables you
to use the same layout field and boilerplate label for
whatever value you enter for the lexical reference on the
Runtime Parameter Form.
If you use lexical references in your SELECT clause, you
must specify the same number of items at runtime as were
specified in the report's data model. Each value you
specify for your lexical references at runtime must have
the same datatype as its Initial Value.
A lexical reference cannot be used to create additional
bind variables after the After Form trigger fires. For
example, suppose you have a query like the following (note
that the WHERE clause is replaced by a lexical reference):
SELECT ENAME, SAL FROM EMP
&where_clauseIf the value of the where_clause parameter
contains a reference to a bind variable, you must specify
the value in the After Form trigger or earlier. You would
get an error if you supplied the following value for the
parameter in the Before Report trigger: WHERE SAL
= :new_bindIf you supplied this same value in the After
Form trigger, the report would run
Reports Builder uses these values to validate a query with
a lexical reference. Create your query containing lexical
references.
| Is This Answer Correct ? | 8 Yes | 2 No |
Substitute multiple values at run time whereas bind
variable subsitute one value at run time
| Is This Answer Correct ? | 6 Yes | 5 No |
What are file in oracle.
Where I can download D2K software?
what is the back ground program run while transferring data from OM to AR?
what is tuning in oracle apps technical
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
what is meant by Drill Down in Discoverer report? why it will be use?
In hierarchical structure of a database? we have write query from where we should start?
what are the mandatory parameters in suppler Conversion?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
how to create requst set in oracle apps and how to send muliple requests at a time,
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
Oracle Apps Technical 
