Answer Posted / oracleapps_learner
BIND VARIABLE :
-- are used to replace a single value in sql, pl/sql
-- bind variable may be used to replace expressions in
select, where, group, order by, having, connect by, start
with cause of queries.
-- bind reference may not be referenced in FROM clause (or)
in place of reserved words or clauses.
LEXICAL REFERENCE:
-- you can use lexical reference to replace the clauses
appearing AFTER select, from, group by, having, connect by,
start with.
-- you can?t make lexical reference in a pl/sql statmetns.
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What are the different components you should consider while defining a responsibility in oracle apps?
can we get profile values in report without using user exists is it possible how?
Tell me how to debug the report?
Can you differentiate between mediator and osb?
How do you register report in oracle apps?
Tell me how to find the custom directory in front end?
how can i print random rows in plsql table
Can you explain the difference between architecture followed in 10g & 11g?
testing tools?
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
what is the differences between internal requisition and internal sales order?
how to print multi lay outs,muti currency,muti language in xml publisher
What do you understand by a set of books?
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
Can u give the Documentation of Custom.pll in oracle apps
