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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Insert varchar value to number field
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.