Home » SQL & PL/SQL » SQL & PL/SQL » Temp table and cursor (merged topics)
Temp table and cursor (merged topics) [message #238625] Fri, 18 May 2007 14:32 Go to next message
spooja
Messages: 25
Registered: May 2007
Junior Member
What is the difference between cursor and temp table?

[Updated on: Sun, 20 May 2007 14:04] by Moderator

Report message to a moderator

Re: Cursor n Temp table [message #238626 is a reply to message #238625] Fri, 18 May 2007 15:22 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Is GOOGLE broken for you?
http://tahiti.oracle.com & Read The Fine Concepts Manual
Temp table and Cursor [message #238870 is a reply to message #238625] Sun, 20 May 2007 13:52 Go to previous messageGo to next message
spooja
Messages: 25
Registered: May 2007
Junior Member
What is the difference between a temp table and a cursor? Where do we use these in particular?
Re: Temp table and cursor (merged topics) [message #238875 is a reply to message #238625] Sun, 20 May 2007 14:10 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Where do we use these in particular?
I don't use temp tables, because they are not needed.

[Updated on: Sun, 20 May 2007 14:11] by Moderator

Report message to a moderator

Re: Temp table and cursor (merged topics) [message #238913 is a reply to message #238625] Sun, 20 May 2007 23:47 Go to previous message
sv.venkat
Messages: 12
Registered: July 2006
Location: HYDERABAD
Junior Member
Cursors and Temptables have got different purposes.Cursors are to access the multirows from the table or any object of the database in the case of temp tables they are used as the scribling pad like structure which will get removed at the end of the session or closer of the transaction.
Previous Topic: ERROR in format
Next Topic: sql query shows matched but not ummatched records
Goto Forum:
  


Current Time: Fri Dec 02 18:54:20 CST 2016

Total time taken to generate the page: 0.20248 seconds