what is meant by bind parameter?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is pay run id ?

1903


How can a process be deployed in soa?

894


How to create a purchase order without a requisition?

848


what is global tempory table?

6748


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1837


what are the balancing segments in AR?

1846


In sequence i want to 11 and 15th values how we will write?

1795


What are file in oracle.

2005


In hierarchical structure of a database? we have write query from where we should start?

1925


what are the different transaction clauses in AR?

1828


In support project one ticket alloted which steps follows manualy tell me ?

2418


how can develope the po variance and po summary report? with tables mandatory columns and query please?

2151


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

861


tell me the scenarios of the independent in reports

2245


Is soa a part of oracle fusion middleware?

813