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.
Printable View
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.
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?