What is a Bind Variable in Oracle Reports6i?

Answer 1

Bind parameter

We can create lexical parameter & bind parameter in the report in the data model query. The bind parameter is used as well and lexical parameter used for ex:

Code (SQL):

SELECT &deptno,ename,deptno FROM emp WHERE empno=:empno

Code (Text):

Lexical parameter has a PREFIX ampersand (&)

Code (Text):

Bind parameter has a PREFIX colon (:)