Sorting column values in ORACLE
Hi,am new to Oracle i need help this query.
VehicleCode Desc STATUS
------------------------------------------
1AB TEST Y
1 TEST1 N
123 TEST2 N
16 TEST8 Y
8 TEST9 N
45 TEST10 Y
8 TEST11 Y
I need result for STATUS should 'Y' record sorting first and 'N" sorting second
Vehilcle Line Code Ascending Order : 1,AB,8,8,16,45,123
help this .
Thanks
Sriram.R