Skip to Main Content
Forums

Oracle Forms

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!

How Insert a number starting with 0

750196Jan 29 2010 — edited Jan 30 2010
Hi,

I have created table numberTable with one column mynumber of datatype number(8).

I want to insert a number into this column 00000000. But when I insert this number it becomes 0 only and my query fails to read 8 digits as it finds only one disgit stored in table. I want all these zero to be present in the column because one of my query read this 8 digit number and use into different application and update it back with increment 1.

Can anyone tell me how can I save this number including with zero.

Thanks in Advance

Regards,
Vipin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2010
Added on Jan 29 2010
#forms, #moved-from-devops, #oracle, #table
7 comments
2,429 views