Question: I've got an oracle query like this:

```
SELECT floatColum0,floatColum1,ROUND(floatColum2,2) from table;

```

which is returning values like that:

```
.2 , 1.23, .23

```

how can I get something like that? (leading zeros)

```
0.2, 1.23, 0.23 ?

```

Answer: 
I think your problem might be Regional Settings.

Make this:

1. Go to Control Panel
2. Regional and Language Settings
3. Customize
4. Display Leading Zeros

and change the value for what you want.
You could try casting it as varchar and using a case statement to add a zero if the first character is a '.' (and adding nothing if its anything else).

Im not an Oracle expert but I dont think you could 'add' zeros without changing data type.