Dynamic order by
Oracle December 8th, 2006
用decode来动态排序：
SELECT DECODE(P_ORDER, 'PROJECT_NUMBER', PROJECT_NUMBER, 'ITEM_NUMBER', ITEM_NUMBER),
PROJECT_NUMBER,
ITEM_NUMBER,
.. .
FROM HX_PO_HXMRPAAB_TMP
ORDER BY 1
刚开始用的时候，习惯性的将decode放到order by中去：
SELECT PROJECT_NUMBER,
ITEM_NUMBER,
.. .
FROM HX_PO_HXMRPAAB_TMP
ORDER BY P_ORDER
这毫无效果。