Hi,
Just wanted to check something, One of my colleagues is getting an error trying to insert data obtained from another database using this statement:
INSERT INTO SALES
select *
from SALES@remote_db
but they get an error due to different data types. This works though.
INSERT INTO SALES
(columnA, columnB, columnC,...)
select columnA, columnB, columnC,...
from SALES@remote_db
So the top statement uses the column order rather than the column name to insert?
I've never had a problem myself but I probably create the columns for the target table in the same order as the source and I wanted to doublecheck what the top statement does.