top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is a Bind Variable in Oracle Reports6i?

+4 votes
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
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.