what is meant by bind parameter?

Answers were Sorted based on User's Feedback



what is meant by bind parameter?..

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

what is meant by bind parameter?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

what is the difference between oracle 8i and 9i?

1 Answers  


can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  


difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,


What is Summary columns?

1 Answers  


Tell me how to find the custom directory in front end?

0 Answers  






How to create a purchase order without a requisition?

0 Answers  


Give a brief overview on OrderManagement.

1 Answers   Zensar,


what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,


what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,


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?

0 Answers  


Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)