Skip to Main Content
Forums

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!

ensuring there is a zero before decimal place

503770Jul 27 2006 — edited Jul 28 2006
This is the PL/SQL statement...
if factor > 1 then
UPDATE tblParam
set MDL = c.MDL*factor
where paramid = c.paramid;
end if;
If c.MDL*factor is less than 1 I want to make sure it is displayed as...
0.xxx
instead of...
.xxx
Anyone?
Message was edited by:
ferrethouse

Message was edited by:
ferrethouse
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2006
Added on Jul 27 2006
8 comments
3,269 views