Bind Parameter Vs Lexical Parameter.

Bind Parameter:

Bind Parameters are denoted by (:) Used to get the value from the User.

An example is:
SELECT *
FROM EMP
WHERE DEPTNO BETWEEN P_FROM AND P _TO

If P_from is entered then it should retrieve all dept from the specified dept

if p_to is entered then it would retrieve up to specified deptno.

WHERE DEPTNO>=:P_FROM

WHERE DEPTNO<=:P_TO

Lexical Parameters:

Lexical parameters (prefixed with '&') are used to build report queries dynamically. 

In reports Lexical parameters are used to create the where clause of the Report query dynamically. 

Example 1: Report with Lexical Parameter Example.

Bind	Lexical
ü  To pass the Values into the WHERE Clause. ü  We will use the symbol “:” ü  Can be used only in the WHERE Clause. ü  Any Data Type. ü  Values will be passed in the Parameter Form.	ü  To Replace the String in the Query. ü  We will use the symbol “&” ü  In any Clause we can use this. ü  Must be Character. ü  Values will be assigned dynamically form                                     in the After Parameter Form Trigger.