I have a need to display (format) a number this way.
Have this: Display this: 0 0+00.00 1 0+01.00 1.5 0+01.50 20 0+20.00 35.75 0+35.75 123400 1234+00.00 55566.75 555+66.75
I did try this:
Select TO_CHAR(1000, '0+00.00') AS STATION
but that does not work. Error: Invalid number format model
Is there any way to format the number in Oracle the way I want?
A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.