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
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?
Don't be that lazy and take a look at INSERT statement syntax then come up with something.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
thank you ..not sure what i was thinking yesterday i used values key word ..
Click Here to Expand Forum to Full Width