SQL Error ORA-00913 too many values

Question

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?

Answer 1

You should specify column names as below. 

insert into abc.employees (col1,col2) 
select col1,col2 from employees where employee_id=100; 

I hope this helps you.