Home » SQL & PL/SQL » SQL & PL/SQL » insertion (oracle 10g)
insertion [message #387650] Fri, 20 February 2009 03:25 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,

i am having a table which contains some one lakh of records.now i want to insert fresh records into that table.but i need that previous data as well.which approach i have to go as there should be no performance problem in it.
Re: insertion [message #387654 is a reply to message #387650] Fri, 20 February 2009 03:34 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
This question makes no sense. Try again, but try to be clearer as to your requirements
Re: insertion [message #387659 is a reply to message #387654] Fri, 20 February 2009 03:48 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
INSERT looks like a valid answer to me ...

There is a table.
It is full of records.
He'd like to insert new records.
He'd also like NOT to lose existing records.

So - don't DELETE, don't TRUNCATE, don't UPDATE - simply INSERT!

Or not?
Re: insertion [message #387662 is a reply to message #387659] Fri, 20 February 2009 03:53 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
yeah exactly, for a certain period of time i want to maintain the old history.but i have to move it to some where and i want to insert.this is acyclic process.
what my question is how can i do this entire thing for saving the old ones and inserting the new ones.but no data is constant here.
Re: insertion [message #387663 is a reply to message #387662] Fri, 20 February 2009 04:00 Go to previous message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Quote:
but i have to move it to some where

Why? Why not just leave it where it is? 1 Lakh isn't exactly a huge number of rows
Previous Topic: duplicate column name
Next Topic: Is there a more effective or better way to write this?
Goto Forum:
  


Current Time: Thu Dec 08 08:43:00 CST 2016

Total time taken to generate the page: 0.09785 seconds