Home » SQL & PL/SQL » SQL & PL/SQL » records from one table to another table.
records from one table to another table. [message #237309] Mon, 14 May 2007 02:39 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


Hi every one,

My oracle version is oracle 9i,

i had a table it contains 50 thousands records are there.

I want to insert all the records from that table to another

table. Both table structure are same.what can i do..please

reply..

Arun..



Re: records from one table to another table. [message #237311 is a reply to message #237309] Mon, 14 May 2007 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
insert ... select ...

Regards
Michel
Re: records from one table to another table. [message #237313 is a reply to message #237309] Mon, 14 May 2007 02:44 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member



0k thanks..
Re: records from one table to another table. [message #237338 is a reply to message #237313] Mon, 14 May 2007 03:32 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please, please, please, please, please.
Take some time to read a book. Do you see what happens if you keep asking your questions here? You get lazy. The questions you ask get easier and easier, because you think it is less work to ask them here then to try and find out yourself.
Previous Topic: No copy parameter
Next Topic: More reading
Goto Forum:
  


Current Time: Sun Dec 04 16:30:28 CST 2016

Total time taken to generate the page: 0.18420 seconds