Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by bind parameter?
- 2 Answers
- 6984 Views
- Satyam, I also Faced
- E-Mail Answers
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 procedure and function
what do u mean by debit/credit memo invoices?
3 Answers ACC, Convergys, Mascon,
Which is the best website to learn Oracle Apps?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
can we execute one concurrent program through another concurrent program?
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
is UOM maintained at master level or organization level or both?
in GL module specifing org_id or not?
can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)
where u do setup of operating unit?
In support project one ticket alloted which steps follows manualy tell me ?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
Oracle Apps Technical 
