How to insert more then one record from one table to another table in oracle,in some specific colums

ROHIT_4444
Profile Answers by ROHIT_4444 Questions by ROHIT_4444
Mar 24th, 2007
4
2083

Questions by ROHIT_4444 answers by ROHIT_4444

Showing Answers 1 - 4 of 4 Answers

ddkdhar
Profile Answers by ddkdhar Questions by ddkdhar

Mar 26th, 2007

you can use
merge statement to insert ( 10g enhanced this facility)or
use
insert into table_name( col1,col2,col3)
select * from table_name1

ROHIT_4444
Profile Answers by ROHIT_4444 Questions by ROHIT_4444

Mar 26th, 2007

MY QUESTION IS HOW CAN WE INSERT MORE THAN ONE ONE RECORD IN A TABLE FROM ANOTHER TABLE (ONLY SOME SPECEFIC COLUMS,NOT ALL COLUMS WANT TO INSERT INTO THE TABLE

ROHIT_4444
Profile Answers by ROHIT_4444 Questions by ROHIT_4444

Mar 27th, 2007

SUPOOSE WE HAVE TWO TABLE R_ITEM_MASTER & ITEM_MASTER

IN R_ITEM MASTER THERE ARE
ITM_ITEM_CODE,ITM_DESC,ITM_UM,ITM_CURR_COST_RATE FOUR FIELDS BUT WE WANT TO INSERT RECORDS ONLY IN TWO COLUMS

INSERT INTO R_ITEM_MASTER (ITM_ITM_CODE,ITM_UM)
SELECT ITM_ITEM_CODE,ITM_UM FROM ITEM_MASTER