Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sam
Bind references are used to replace a single value in SQL
or PL/SQL. Specifically, bind references may be used to
replace expressions in SELECT, WHERE, GROUP BY, ORDER BY,
HAVING,CONNECT BY, and START WITH clauses of queries.
Bind references may not be used in a FROM clause.
An example is:
SELECT ORDID,TOTAL
FROM ORD
WHERE CUSTID = :CUST
Lexical references are placeholders for text that you embed
in a SELECT statement, when you want the parameter to
substitute multiple values at runtime. You can use lexical
references to replace the clauses appearing after SELECT,
FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and
START WITH. You cannot make lexical references in PL/SQL.
Before you reference a lexical parameter in a query you
must have predefined the parameter and given it an initial
value.
An example is:
SELECT ORDID, TOTAL
FROM &ATABLE
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
In oracle application how do you debug or trace errors?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
what are the prerequisites for costing transactions?
Explain what are the tables of auto invoice?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How can a process be deployed in soa?
Can u give the Documentation of Custom.pll in oracle apps
What is the concept of soa governance?
How can we import the data into a database using sql * loader?
How is choreography different from orchestration?
Do you know what is applysys in oracle application database schema, what is apps?
What is count(*) from po_vendors(any table)?
What do you understand by a set of books?
how to print multi lay outs,muti currency,muti language in xml publisher
