how to insert rows from another table except one column
Hi
I have a table NEXT_OF columns (sysid,name,address,city...) in one database, in other database I have same table and structure however the column sysid has sequence to generate new one. remaining columns I want from first database
INSERT INTO NEXT_OF (SELECT * FROM NEXT_OF@V8_V6_LINK, here V8_V6_LINK); is database link
now I want null value for sysid and for rest of the columns from first database of NEXT_OF table, please guide how do I update this.
I know that I can insert by using below however I have 20 columns write and I need to update 27 tables like this
INSERT INTO NEXT_OF (SELECT NULL,NAME,ADDRESS,CITY FROM NEXT_OF@V8_V6_LINK);
plz help me out
Regards
Chakri