Hi,

I have a query below

select * from emp
where deptno = &dpt
order by decode(.......)

If I enter dpt 10 then I need
order by ename

If I enter dpt 20 then I need
order by hiredate,job,sal

If I enter dpt 30 then I need
order by deptno,ename

How I can achive this. Thanks in advance.