what is meant by bind parameter?
Answers were Sorted based on User's Feedback
Answer / jay
Bind parameters are used to substitute one value at runtime
for evaluation and are identified by a preceding ‘:’. An
example of a bind parameter in a select statement is
provided below, where :P_EMP is the bind parameter
reference.
Example:
select *
from emp
where emp.name = :P_EMP;
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / sridhars.s
->there are denoted by columns
->it accepts single automic value
->bind parameters can be included in lexical parameter
->there parameters are denoted by ':'
exp: :num
Is This Answer Correct ? | 0 Yes | 1 No |
what is the difference between oracle 8i and 9i?
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
difference between 2 way and 4 way matching
What is Summary columns?
Tell me how to find the custom directory in front end?
How to create a purchase order without a requisition?
Give a brief overview on OrderManagement.
what are the prerequisite set ups for inter organization transaction?
what is difference between d2k report and oracle apps report
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can 2 functions have same name & input parameters but differ only by return datatype ?