Calculation in Oracle WebDB

From: Robert Johnson <wibble999_at_hotmail.com>
Date: 16 Jan 2002 00:24:59 -0800
Message-ID: <c8aa4485.0201160024.163c524b_at_posting.google.com>

A quick question and I hope this is the right newsgroup...

When performing a simple calculation in WebDB, how is it possible to display a zero in front of a decimal calculation?

The line is....

''|| substr(100 * sl.AANTAL_GESPREKKEN / sl.AANTAL_KANDIDATEN, 1,4)|| '%'cvs_to_interview,

but when the calculation is performed a result is shown as .935% instead of 0.935%.

Thanks for any help!

Regards

Robert Received on Wed Jan 16 2002 - 09:24:59 CET