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
what are the balancing segments in AR?
What do you understand by soa and what are the benefits of using this architecture?
How to create a purchase order without a requisition?
Can u give the Documentation of Custom.pll in oracle apps
What do you understand by concurrent programs?
What is oracle soa suite?
How can a process be deployed in soa?
What is count(*) from po_vendors(any table)?
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
is it possible to run the interface without using oracle apps?
what are the different transaction clauses in AR?
How can you achieve loose coupling in soa framework?
In support project one ticket alloted which steps follows manualy tell me ?
Can we create tables in apps schema?
how can i print random rows in plsql table
