top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is a Bind Variable in Oracle Reports6i?

+4 votes
148 views
What is a Bind Variable in Oracle Reports6i?
posted Feb 4, 2016 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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 (:)
answer Feb 5, 2016 by Manikandan J
...