Hi,
I want to use decode in order by in following way -

select * from dept
order by decode(.......)

if deptno=1 then order by deptname desc, deptcity asc
if deptno=2 then order by deptno desc, deptname asc, deptcity desc
else
order by deptno desc, deptcity asc.

Can anyone please help me?

Thank you in advance.