Oracle NUMBER format

[Tracer]

Not being an Oracle expert, I'm running into a little problem. I have an Oracle database which is storing decimals as numbers (i.e. 2.15 == 215).. When selecting out of the database, how do I get 2.15 instead of 215?

Or must I do this in PHP? I would hate to have to use substr to reformat...

Thanks,

[Roger_Ramjet]

You should have specified the number of decimal places for the column when the table was created. You can use NUMBER_FORMAT in your query to correct the format.

[Tracer]

Yeah, Unfortunately database schema was setup by a proprietary vendor...

That was exactly what I was looking for... Thank You