SQL & PL/SQL

Hi all,

I got the script to have the output of the date (dt) to be sort in descending order, but some how rather it was not able to sort the date field. It seem that system only sort on the DD as for the output shown :-

Date
29/06/2010
27/07/2009
26//03/2008
21/01/2011
15/05/2008
14/07/2009

I need to have in descending mode as :
Date
21/01/2011
29/06/2010
27/07/2009
14/07/2009
15/05/2008
26/03/2008

How to possible arrive this ?

My sql script :-
SELECT A.* , COUNT(ITEM) OVER ( partition by item, code ) CNTA FROM (
SELECT dt, item, CODE , recp, VAL
FROM ( SELECT t.*, COUNT( CASE WHEN code LIKE 'CRE%' OR code LIKE 'MAR%' OR code LIKE 'UTH%' OR CODE LIKE 'RIN%' THEN 1 ELSE NULL END) OVER(PARTITION BY ITEM ) cnt
FROM ( SELECT to_char(OS.SL_DT, 'dd/mm/yyyy') DT, OS.sl_item_code ITEM , OS.SL_REF CODE, (OS.sl_val_1) recp, B.CGCV_VALUE_1 VAL
FROM OS_STK_LEDGER OS, ( SELECT cgcv_item_code, CGCV_STK_QTY_BU, CGCV_COST_1, CGCV_VALUE_1
FROM OS_COST_GROUP_CURR_VAL
WHERE CGCV_COST_GROUP_CODE = 'ACOSG'
AND CGCV_GRADE_CODE_1 = 'G1' ) B
WHERE OS.sl_dt <= TO_DATE('30/06/2012', 'dd/mm/yyyy')
AND OS.sl_rcvd_issd = 'R'
AND (OS.sl_txn_code = 'SGRN' OR OS.sl_txn_code = 'PGRN' OR OS.SL_TXN_CODE = 'SAOP' )
AND B.CGCV_ITEM_CODE(+) = OS.SL_ITEM_CODE
AND OS.SL_COST_GROUP_CODE(+) = 'ACOSG'
AND sl_grade_code_1 = 'G1' ) t)
WHERE CNT > 0
AND ITEM = '10-07-103'
ORDER BY dt desc ) A

Thanks.
Lim