What are Lexical Parameters.How They are used in Reports 6i
Answers were Sorted based on User's Feedback
Answer / jini
you have to write a query like this to replace the
tablename and column name
but make sure emp is a table and ename,sal are columns
|Is This Answer Correct ?||33 Yes||10 No|
1.Lexical Parameters are placeholders for text 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
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
we can use (&)lexical parameter in where cluse and inside
from clause and group by clause i enclose the query used in
types.cust_trx_type_id ) dummy_id_inv,
from ra_cust_trx_types_all types,
where TRUNC(ps.gl_date) <= :p_as_of_date
and ps.customer_trx_id+0 = trx.customer_trx_id
and ps.customer_id = cust_acct.cust_account_id
and cust_acct.party_id = party.party_id
and ps.cust_trx_type_id = types.cust_trx_type_id
and nvl(ps.org_id,-99) = nvl(types.org_id,-99)
and ps.customer_site_use_id+0 = site.site_use_id+)
and site.cust_acct_site_id = addr.cust_acct_site_id(+)
and addr.party_site_id = party_site.party_site_id(+)
and loc.location_id (+) = party_site.location_id
and ps.gl_date_closed > :P_AS_OF_DATE
and ps.customer_trx_id+0 = gld.customer_trx_id
and gld.account_class = 'REC'
and gld.latest_rec_flag = 'Y'
and gld.code_combination_id = cc.code_combination_id
|Is This Answer Correct ?||27 Yes||11 No|
Explain the purpose of %type and %rowtype data types with the example?
What is the usage of NVL?
When do we create bitmap indexes
what is a constraint? Tell me about its various levels. : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#
what is meant by databases
Can we use rowid as primary key?
What is Highwatermark?
What is a natural join?
What are inbuilt functions in sql?
How to display the contents of a current record fetched in a reference cursor?