Register or Login to Your Account
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.
can not you change the data type to varchar2 ?
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.
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
You cannot add leading zeros to a number. Leading zeros for number have no value either in mathematical or in computer science