SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

?LPAD with 0 for number less than 1 or -1

ricard888Jun 10 2010 — edited Jun 10 2010

I want to find a function to return a 0 (zero) in front of a decimal point. Eg .90 I want it to be 0.90 or -.90 will be -0.90.

Much appreciated
Ricard

This post has been answered by Centinul on Jun 10 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2010

Added on Jun 10 2010

10 comments

1,710 views