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.