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
Can we create tables in apps schema?
List the various types of value set.
In oracle application how do you debug or trace errors?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
How can you achieve loose coupling in soa framework?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Do you know where we can check the status of po?
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
please send me forms, xml pulisher questions,answers
Can you explain the difference between architecture followed in 10g & 11g?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How to move the one file from one instance to another instance? And your scripts also?
What is sca and how is it useful?
What are the different components of soa suite?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP