SELECT * FROM table_name ORDER BY decode( col_name, ‘value1‘, 1, ‘value2‘, 2, ‘value3‘, 3, ‘value4 ‘, 4, valueN‘, N )
oracle order by 自定义排序
原文：https://www.cnblogs.com/lin02/p/12096148.html
