OraFAQ Forum: SQL & PL/SQL » Cursor Vs Subquery

Home » SQL & PL/SQL » SQL & PL/SQL » Cursor Vs Subquery

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cursor Vs Subquery [message #254213]

Thu, 26 July 2007 03:22

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

Report message to a moderator

Re: Cursor Vs Subquery [message #254218 is a reply to message #254213]

Thu, 26 July 2007 03:35

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL is better than PL/SQL.

Regards
Michel

Report message to a moderator

Re: Cursor Vs Subquery [message #254231 is a reply to message #254218]

Thu, 26 July 2007 04:10

ursmadly
Messages: 13
Registered: July 2007
Location: united kingdom

Junior Member

thanks a lot

Report message to a moderator

Previous Topic:	dumb title.
Next Topic:	How to add millisecond to TIMESTAMP datatype value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 05:11:54 CST 2024