Home » SQL & PL/SQL » SQL & PL/SQL » Cursor Vs Subquery
Cursor Vs Subquery [message #254213] Thu, 26 July 2007 03:22 Go to next message
ursmadly
Messages: 13
Registered: July 2007
Location: united kingdom
Junior Member
Hi,

I have a tables with 100,000 records each, so if i have to insert these rows into a another table using multiple conditions , which would perform better sub queries in a insert statement or the for loop cursor.

thanks,
GIlbert
Re: Cursor Vs Subquery [message #254218 is a reply to message #254213] Thu, 26 July 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL is better than PL/SQL.

Regards
Michel
Re: Cursor Vs Subquery [message #254231 is a reply to message #254218] Thu, 26 July 2007 04:10 Go to previous message
ursmadly
Messages: 13
Registered: July 2007
Location: united kingdom
Junior Member
thanks a lot
Previous Topic: dumb title.
Next Topic: How to add millisecond to TIMESTAMP datatype value
Goto Forum:
  


Current Time: Sat Dec 03 07:43:49 CST 2016

Total time taken to generate the page: 0.05884 seconds