Question: what is the difference between bind and lexical parameter?
Answer: 1-Bind parameters are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. 2-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.