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
How many schemas we have? how many you have used?
What is oracle soa suite and what are its different components?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Is soa a part of oracle fusion middleware?
What is instead of trigger in where we will use?
In hierarchical structure of a database? we have write query from where we should start?
What is the concept of soa governance?
Can we create tables in apps schema?
Plz anybody send me Technical specification for AP Interface
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What are file in oracle.
where to define interorganization transaction charges and what are the different options?
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 to move the one file from one instance to another instance? And your scripts also?
