insert

[prodadmin]

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

[PAVB]

Perhaps by naming the columns you want to insert?

Don't be that lazy and take a look at INSERT statement syntax then come up with something.

[mdvreddy]

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

[prodadmin]

thank you ..not sure what i was thinking yesterday i used values key word ..