The table name, column names, datatype, and size of the two tables are all the same. These tables are in different databases, but I'm used to logging in as the HR user at the moment.
insert into abc.employees select * from employees where employee_id=100;
I can not give use original query from corporate office.
Error starting at line 1 in command:
insert into abc.employees select * from employees where employee_id=100;
Error at Command Line:1 Column:25
Error report:
SQL Error: ORA-00913: too many values
00913. 00000 - "too many values"
*Cause:
*Action:
Can someone please help me with this?