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 do's and dont's of Interface?
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?
Can you define an erp system?
Explain what are the tables of auto invoice?
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
How many schemas we have? how many you have used?
what is the differences between internal requisition and internal sales order?
what is the difference between request group and request security in oracle apps?
What are the benefits of using soa architecture?
List the various types of value set.
Tell me where we find the status of order information?
do you know is it possible to run the interface without using oracle apps?
how to print multi lay outs,muti currency,muti language in xml publisher
Plz anybody send me Technical specification for AP Interface
What is a value set? List its various types.