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!

insert number starting with '00'

422762Aug 17 2006 — edited Aug 17 2006

Hi, this is probably an easy one but its causing me a few problems at the moment.

I'm inserting data into a number(3) field of type '003','004' etc. When i query the data thats been inserted the leading zero's have been removed. I'd like to keep this field as a number field so is there a way I can format the data when I'm inserting so that the zeros remain? I'd like to query it and see 003, 004 rather than 3,4

thanks,
Ian

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2006

Added on Aug 17 2006

22 comments

5,873 views