Difference between Bind and Lexical parameter

 Difference between Bind and Lexical parameter

Bind Parameter	Lexical Parameter
Bind parameter are used to pass a single value in sql, pl/sql	lexical parameter may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.
It is started with Colon (:)	It  is started with Amparsign (&)
It is used to accept the value when executing the query	It is used to build report queries dynamically
It is used in (select, where, order by group by ) but not in from.	It is used in all clause.
select * from emp where emp_no=:emp_no;	select * from emp where &condition;
It is used both sql & pl/sql.	It is used only in sql.