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

where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  


How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  


The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,


What is the difference between base table and multi-org table?

3 Answers   Infosys,






where we find the status of order information.

2 Answers  


for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  


Types of cursors?

3 Answers  


is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,


while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  


What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,


wht is format triger?

4 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)