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
how do you describe O2C along with tables
where to define interorganization transaction charges and what are the different options?
What is a value set? List its various types.
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
tell me the scenarios of the independent in reports
What is instead of trigger in where we will use?
How many schemas we have? how many you have used?
What do you understand by soa?
How do you register report in oracle apps?
what is global tempory table?
What are the Standard Reports and Forms in HRMS?
How to create a purchase order without a requisition?
In support project one ticket alloted which steps follows manualy tell me ?
Explain oracle apps architecture.
How to move the one file from one instance to another instance? And your scripts also?
