Home » SQL & PL/SQL » SQL & PL/SQL » Ref cursor (Oracle 10g)
Ref cursor [message #327378] Mon, 16 June 2008 04:42 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
Kindly help me.Performance wise which one is better and why ?
1) Strong cursor
2) Weak cursor
Re: Ref cursor [message #327381 is a reply to message #327378] Mon, 16 June 2008 04:47 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
What Performance is doing here??

These two cursor types have different usauge.How will you compare it.

Re: Ref cursor [message #327385 is a reply to message #327378] Mon, 16 June 2008 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no difference for performances point of view.

Regards
Michel
Re: Ref cursor [message #327453 is a reply to message #327378] Mon, 16 June 2008 08:06 Go to previous messageGo to next message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
if u want to return any value tehn u will u strong refcursor, other wise u will use weak refcursor, strong refcursor is bettor bcz it can be fetch values from different data
Re: Ref cursor [message #327462 is a reply to message #327453] Mon, 16 June 2008 08:30 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you want to post in english?
You posted 7 answers, there are all in an ununderstandable and muddy language.
Read and FOLLOW OraFAQ Forum Guide.

Regards
Michel
Previous Topic: Use Alias in Query
Next Topic: Data from Excel sheet to oracle table
Goto Forum:
  


Current Time: Sat Dec 03 07:54:40 CST 2016

Total time taken to generate the page: 0.15343 seconds