Interested to Buy Any Domain ? << Click Here >> for more details...
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 IS CUSTOM VIEW AND CUSTOM COMPONENT?
What is sca and how is it useful?
What is instead of trigger in where we will use?
tell me the scenarios of the independent in reports
How to move the one file from one instance to another instance? And your scripts also?
What are the different components of soa suite?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How can a process be deployed in soa?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Can you define an erp system?
What do you understand by soa and what are the benefits of using this architecture?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Explain what are the tables of auto invoice?
Do you know where we can check the status of po?
tell my any difficult situtation you solved in your experience in your company?
