Sorting/No Sorting

[sunny313]

I am trying to get the results of following SQL displayed in the order of selection as follows:

select dept_code, dept_name from dept
where dept_code IN ('B', 'C', 'A');

Goal is to get the results in the order of dept_code listed in IN_CLAUSE:
Dept_code Dept_name
---------------------------
B DeptB
C DeptC
A DeptA

Please help.

[jmodic]

select dept_code, dept_name from dept
where dept_code IN ('B', 'C', 'A');
ORDER BY DECODE(dept_code, 'B', 1, 'C', 2, 'A',3)