Tuesday, August 30, 2011

Difference between Bind Parameter and Lexical Parameter

What is the difference between bind parameter and lexical parameter?

1 comment:

  1. Bind parameter is prefixed with ':' and it is used to accept the value when executing the query and

    Lexical parameter is prefixed with '&' and are used to build report queries dynamically

    Both bind and lexical parameters can be used in oracle reports