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.