Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you describe O2C along with tables
is it possible to run the interface without using oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
what is the difference between request group and request security in oracle apps?
How many schemas we have? how many you have used?
What are the Standard Reports and Forms in HRMS?
Plz anybody send me Technical specification for AP Interface
What does appl_top directory contain?
In hierarchical structure of a database? we have write query from where we should start?
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?
What is sca and how is it useful?
List the various types of value set.
testing tools?
can we get profile values in report without using user exists is it possible how?
