Answer Posted / alladi venkateswarlu
1)BIND PARAMETERS ARE USED TO PASS NUMERIC VALUES TO THE
QUERY AT RUN TIME.INCLUDING DATE TYPE ALSO
LEXICAL PARAMETERS ARE USED TO PASS ANY TYPE OF
PARAMETERS.
2)BIND PARAMETERS ARE STARTED WITH :(COLON) SYMBOL
WHERE LEXICAL PARAMETERS START WITH &(AMPERSAND) SYMBOL
3)BIND PARAMETERS ARE USED IN ANY CLAUSE(SELECT,ORDER
BY,GROUP BY,..) OTHER THAN FROM CLAUSE IN THE QUERY
WHERE AS LEXICAL PARAMETERS ARE USED IN ALL CLAUSES EVEN
IN FROM CLAUSE
4)BIND PARAMETERS AE USED IN BOTH SQL AND PL/SQL
WHERE LEXICAL PARAMETERS ARE USED IN ONLY SQL
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is a value set? List its various types.
tell me the scenarios of the independent in reports
do you know is it possible to run the interface without using oracle apps?
What are the benefits of using soa architecture?
What is the concept of soa governance?
how to print multi lay outs,muti currency,muti language in xml publisher
What do you understand by concurrent programs?
what is the differences between internal requisition and internal sales order?
What is instead of trigger in where we will use?
How is choreography different from orchestration?
please send me forms, xml pulisher questions,answers
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What does appl_top directory contain?
In sequence i want to 11 and 15th values how we will write?
What are the different components you should consider while defining a responsibility in oracle apps?