Inset statement haywire

[rishab]

This is the insert statement

insert into INFRA.TBL_MST_SIM (I_MOB_NO,I_SIM_NO,S_VENDOR,S_SIM_TYPE,S_CURR_POSITION,C_STATUS,DT_CREATED) values (9748499557,89913100000031926675,'AIRTEL-KOL','NON-VOICE',NULL,NULL,sysdate);

this is the table structure
INFRA.TBL_MST_SIM
Name Null? Type
----------------------------------------- -------- ----------------------------
I_MOB_NO-----------------------------------------NUMBER(10)
I_SIM_NO-----------------------------------------NUMBER(30)
S_VENDOR-----------------------------------------VARCHAR2(50)
S_SIM_TYPE-----------------------------------------VARCHAR2(30)
S_CURR_POSITION-----------------------------------------VARCHAR2(50)
C_STATUS-----------------------------------------CHAR(1)
DT_MODIFIED-----------------------------------------DATE
DT_CREATED-----------------------------------------DATE
S_MODIFIED_BY-----------------------------------------VARCHAR2(15)
S_CREATED_BY-----------------------------------------VARCHAR2(15)
C_IS_DELETED-----------------------------------------CHAR(1)

The error filed is "I_SIM_NO"

data is getting inserted correctly but when I try to see the data all what its showing is

select I_MOB_NO,I_SIM_NO from INFRA.TBL_MST_SIM;
________________________________
I_MOB_NO I_SIM_NO
_________________________________
9748499557 8.9913E+19


what is wrong can any one tell me?

[paragp1981]

i am not sure but either of below 2 should work.
1)try "set long 1000000" before that select increase 0 if needed
2)try col I_SIM_NO format 999999999999999

[vnktummala]

1. Find the max length of the column "I_SIM_NO"
select max(length(i_sim_no)) from INFRA.TBL_MST_SIM;
2. Format the column accordingly.
col i_sim_no for 99999999999999999999999;

Thanks,