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!

TO_CHAR tricks

422560Aug 5 2004 — edited Aug 9 2004

I have a variable with a length of 7 with 3 implied decimal places. It is used to store hours of service.

If the number is 1000 hours, it should be 1000000.

It show up like 0001000 which on a report looks like 1.000 hour vs. 1000.000 hours (Big Difference)

How do I duplicate this with a PL/SQL function?

Any help would be greatly appreciated!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2004

Added on Aug 5 2004

14 comments

404 views