1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as mni
SQL>
SQL> With Data As (
2 Select -20.79000 as num from dual union all
3 Select 6.25000 as num from dual union all
4 Select 2.50000 as num from dual union all
5 Select 0.00000 as num from dual union all
6 Select 6.30000 as num from dual union all
7 Select 12.60000 as num from dual union all
8 Select 40.83000 as num from dual union all
9 Select 166.67000 as num from dual union all
10 Select 83.3300 as num from dual union all
11 Select 9.45000 as num from dual union all
12 Select -6.25000 as num from dual union all
13 Select 2.99000 as num from dual union all
14 Select 11.96000 as num from dual
15 )
16 Select to_char(num,'999D99999')
17 From data
18 Order By num
19 /
TO_CHAR(NUM,'999D99999')
------------------------
-20,79000
-6,25000
,00000
2,50000
2,99000
6,25000
6,30000
9,45000
11,96000
12,60000
40,83000
83,33000
166,67000
13 rows selected
SQL> |
Partager