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
In support project one ticket alloted which steps follows manualy tell me ?
How many schemas we have? how many you have used?
In sequence i want to 11 and 15th values how we will write?
is it possible to run the interface without using oracle apps?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Tell me where we find the status of order information?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
In oracle application how do you debug or trace errors?
how can i print random rows in plsql table
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
do you know is it possible to run the interface without using oracle apps?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is the concept of soa governance?
Tell me how to debug the report?
How can we import the data into a database using sql * loader?