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: 
It isn't the numbers whose leading zeroes are being `cut`, but rather the **string representation** of the number. Mostly this is not a concern as application logic is used with data from a database, which works with the actual data (in this case the number itself) and not its string representation. But if you absolutely require this, you can format the string within the query:

```
SET numformat 99.99;
SELECT floatColum0,floatColum1,ROUND(floatColum2,1) from table;

```

This should do the trick, but again remember, it is a pretty pointless exercise. For additional details: <http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#SQLRF00211>
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.