Rama Krishna,Yerra

• Aug 2nd, 2006

 

The Major Diffrence between  Lexical and Bind varible is

If you want to give a run-time condition in a query of the forms,we have to use Lexical varibale..A Bind varible is a varible which is declare with the predefine statement VARIABLE and it has to represented with symbol  (:) in the programming body.

Thanks&Regds

Ramki,TCS,Dp HYd

sameeridol21

 Profile Answers by sameeridol21 

• Jul 21st, 2010

 

The main diff betn lexical and bind variable  as follows

Bind reference will substitute a single value in PL/SQL whereas lexical variables are used to substitute multiple value.  Bind variable can be on any data type (like char,date,number etc) Whereas lexical variable is only supports Varchar2 datatype.

 

Thanks & Regard

Ghanshyam 

VENKATESH

• Aug 19th, 2011

 

Flex means to store the data for feature purpose.
Bind variable means it returns single column..
Lexical means it return multiple columns..

rihan khan

• Jul 7th, 2014

 

by using lexical parameters we can send only one parameter value

by using bind parameters we can send more then one parameter value

amruta shinde

• Aug 5th, 2014

 

Bind variables are used for replacing the single parameter in the select statement, where as Lexical Parameter is used to replace the where, order by conditions at run time

kamaraj

• Mar 23rd, 2019

 

In Oracle reports only 2 parameters
1. Bind parameter replaces single value in SQL, it is prefixed with :symbol
2. Lexical parameter replaces a statement in SQL, it is prefixed with &symbol