OraFAQ Forum: SQL & PL/SQL » Temp table and cursor (merged topics)

Home » SQL & PL/SQL » SQL & PL/SQL » Temp table and cursor (merged topics)

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

Temp table and cursor (merged topics) [message #238625]

Fri, 18 May 2007 14:32

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Is GOOGLE broken for you?
http://tahiti.oracle.com & Read The Fine Concepts Manual

Report message to a moderator

Temp table and Cursor [message #238870 is a reply to message #238625]

Sun, 20 May 2007 13:52

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?

Report message to a moderator

Re: Temp table and cursor (merged topics) [message #238875 is a reply to message #238625]

Sun, 20 May 2007 14:10

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

Previous Topic:	ERROR in format
Next Topic:	sql query shows matched but not ummatched records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 16:04:05 CST 2024