What is a lexical parameter in Oracle Report Builder


Lexical Parameter is used to replace the where clause at run time. Lexical Parameter identified by & sign and are used to execute query dynamically.

Example

Select * from employee
&where

Comments

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle