Discussion Locked
Insert varchar value to number field
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can i insert the values like this
INSERT INTO sara SELECT To_Number(agreementid) from emp
Here sara table have agreementid as number(18,4)
emp table have agreementid as varchar(255) but it contains only number in that field.
While inserting i got ORA-01722 INVALID NUMBER error. I check there is not character in that field.
Can anybody help me to insert from one table to another.