-
insert
Hi,
how di i nsert partial columns into tablex from table y
i have tableX which has 4 columns and i have tableY with 2 columns matches the data type of tableX
TableX
column1
column2
column3
column4
TableY
column1
column2
i would like to insert into table X column1 and 2 from TableY column1 and column2
-
Perhaps by naming the columns you want to insert? :rolleyes:
Don't be that lazy and take a look at INSERT statement syntax then come up with something.
-
however here it is one:
INSERT INTO tableX (column1,column2 ) select column1,
column2 from TableY;
ARE you oracle guy? IF yes, it’s very misfortune that you do not know insert statement syntax, better join a training center or read oracle documentation.
Cheers
/MR
-
thank you ..not sure what i was thinking yesterday i used values key word ..