I cant figure out how to select the following:
123 -> 123.00000
123.12 -> 123.12000
123.123456 -> 123.123456
I would like to expand the number of decimal places to for example 5 decimal places (minimum) If there are no decimal places at all there should be 5 zeros. It is fine if there are more then 5 decimal places.
SELECT ROUND(123,5) FROM DUAL;
will result: 123 instead of 123.00000
The number has a default precision.
Is this possible or should I convert it to a varchar with the oracle number formats?
I am using Oracle 10g with plsql.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)