Oracle - how to insert more then one record from one table to another table in oracle,in some specific colums

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 124 of 244

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

Total Answers and Comments: 4

Last Update: November 16, 2007 Asked by: ROHIT_4444

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 26, 2007 00:02:24

ddkdhar

Member Since: June 2006 Contribution: 48

RE: how to insert more then one record from one table ...

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

Is this answer useful? Yes | No

March 26, 2007 00:16:16

ROHIT_4444

Member Since: March 2007 Contribution: 19

RE: how to insert more then one record from one table ...

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

Is this answer useful? Yes | No

March 27, 2007 00:13:56

ROHIT_4444

Member Since: March 2007 Contribution: 19

RE: how to insert more then one record from one table ...

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

Is this answer useful? Yes | No

November 16, 2007 02:36:26

rajakumar_na

Member Since: November 2007 Contribution: 26

RE: how to insert more then one record from one table ...

Try it through MERGE

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank