exec :deptno:=20; 
 select * from emp where deptno=:deptno;