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!

Conversion of NUMBER to DECIMAL

569815May 7 2007 — edited May 7 2007

I am querying a field that is a NUMBER(3,1) data type and I need to have it returned as a DECIMAL with two decimal points. For example, 5 would be returned as 5.00.

Thanks,
Sushi Lover

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2007

Added on May 7 2007

5 comments

56,571 views