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 difference between procedure and function
how will u do documentation
what is unit of measure classes? give atleast two examples. name the underlying table.
What is Place holder Columns?
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
what is the data type of lexical parameter?
How can we import the data into a database using sql * loader?
what are the prerequisites for costing transactions?
What are the different components you should consider while defining a responsibility in oracle apps?
WHAT IS USE OF APPS API?
how can develope the po variance and po summary report? with tables mandatory columns and query please?