What Is The Difference Between Bind And Lexical Parameter?

1.	What Is The Difference Between Bind And Lexical Parameter?
Answer» Bind PARAMETERS are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. Lexical parameters are placeholders for text that you EMBED in a SELECT statement. Use Lexical reference when you want the parameter to SUBSTITUTE multiple values at runtime. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

Answer»

Bind PARAMETERS are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date.
Lexical parameters are placeholders for text that you EMBED in a SELECT statement. Use Lexical reference when you want the parameter to SUBSTITUTE multiple values at runtime. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

Discussion