Using Substitution Variable in Report Builder

Hi there,

   How can one use the substitution variable in Report Builder at runtime so that the end user has
the option of using the where clause with any field/column of his choice. In SQL*Plus, the follwoing
query works fine:  

 select empno,ename,&column_name
from emp
where &condition1 and &condition2
order by &order_column;

but when I uses the same syntax in the query builder of report builder, syntax errors are given. Any
ideas? How can we use the same query in Report Builder? I have used query in Report Builder having one
or more columns defined as bind variable so that their values are given at runtime having the following
syntax:

select ename,sal,job
from emp
where empno = :P_1;

similarly I have used the follwoing query in report builder and it works fine for only one column:

SELECT ALL EMP.ENAME, EMP.JOB, EMP.HIREDATE, EMP.SAL,emp.deptno FROM EMP
 &P_1

if I want to add another column what will be the syntax?

I want that the end user should have the option of using any column/field with the where clause at runtime so that he is not restricted to give values of only those columns which have been previously defined
in the query.

Thanks in advance.

Hassan Received on Fri Mar 22 2002 - 15:58:03 CET