Column

[shamsher]

Can i have column in variable in where condition in query for example:

select * from emp
where a = 10;

a = deptno

how is possible, plz send me.

[slimdave]

It's a strange thing to want to do, and the nearest i can get to is is to alias the column name, like ...

create view emp_v
as
select emp, dept a
from emp

Why do you want to do this?