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!

number not showing zero after decmial.

947771Feb 21 2013 — edited Feb 28 2013

hi,
i have a column
NUMBER(13,4)

when i insert 234.000

in show only 234

where as when i insert 234.12
i shows 234.12

is there any setting by which i can show 234.0000

yours sincerly

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2013

Added on Feb 21 2013

13 comments

665 views