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!

want to put prefix 000 in front of numberic value

SIVASANKAR.SNov 28 2006 — edited Nov 28 2006

hi

i am maintaining a numeric datatype for the isdcode in the telephone details table.

I want to maintain the data with the prefix of 0 in front of the code but it got trimmed because of the number datatype.

otherwise i have to change that as varchar2 datatype.

is it possible to maintain like that?
thanks in advance.
siva

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2006

Added on Nov 28 2006

11 comments

1,204 views