Topic:   I have a column with data type as -Number-
Jul 09, 2014 04:24 6 Replies 497 Views shoson30
Prev Next
Topic Replies (6)
  1. 1
    idnkx user

    shoson30

    Hi,
    I have a column with data type as "Number" and when i am trying to insert number "00123456" which begins with "00" it is remvoing the "00" from it and inserting only "123456".
    is there a way to insert these "00" as well without changing the datatype.

    1
    idnkx user

    Srinik

    can not you change the data type to varchar2 ?

    1
    idnkx user

    shoson30

    thanks. yes, changing the data type wil work. but I have huge volumes of data in the table. so i do not want to change the data type.

    1
    idnkx user

    Srinik

    you can create a temp column and inset the existing data to temp column then change the column data type ...later you can move the data from temp column to original column

    1
    idnkx user

    Asadul

    You cannot add leading zeros to a number. Leading zeros for number have no value either in mathematical or in computer science

Leave a Reply
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect