General discussion


Insert varchar value to number field

By saravanan.shanmugam ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums