Home » SQL & PL/SQL » SQL & PL/SQL » what is the difference between "REF CURSOR" AND "SYS_REFCUSOR"
icon4.gif  what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304427] Wed, 05 March 2008 03:02 Go to next message
lzfhope
Messages: 67
Registered: July 2006
Member
hi,
PL/SQL REF CURSOR TYPE can be strong type and weak Type.
I declare ref cursor type var in two ways:
1) Type t_ref is REF CURSOR return ...;
Vday t_ref;
2) Vday Sys_refcusor;
Up to now,the var will work well.
But ,i want to know the difference.
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304430 is a reply to message #304427] Wed, 05 March 2008 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Answer is direclty in the documentation so it is not an expert question.

Regards
Michel
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304434 is a reply to message #304427] Wed, 05 March 2008 03:32 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member

[MC: Removed copyrighted extract from Steven Feuerstein's book "Oracle PL/SQL LanguagePocket Reference".]

regards,

[Updated on: Wed, 05 March 2008 04:04] by Moderator

Report message to a moderator

icon14.gif  Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304436 is a reply to message #304434] Wed, 05 March 2008 03:40 Go to previous messageGo to next message
lzfhope
Messages: 67
Registered: July 2006
Member
Laughing
thank you very much!
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304440 is a reply to message #304434] Wed, 05 March 2008 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@mshrkshl

When you quote a document or someone else, at least say you quote it or better post a link to it.
Don't steal other work.

Regards
Michel
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304453 is a reply to message #304427] Wed, 05 March 2008 05:05 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
ok. Sad

thanks and regards,

[Updated on: Wed, 05 March 2008 05:22]

Report message to a moderator

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304462 is a reply to message #304427] Wed, 05 March 2008 05:22 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

Ref Cursor:
type r is ref cursor;
r1 r;

Sys ref cursor;
r sys_refcursor;

Thanks
Mano

Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304479 is a reply to message #304462] Wed, 05 March 2008 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hmm, pretty good explaination.
You remind me my grand-mother when I was a child and I asked her: "what does "build" mean?" and she answered me: "build is build, build a building for instance".

Regards
Michel
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304507 is a reply to message #304479] Wed, 05 March 2008 07:36 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
sounds like your granny wasn't very much into spoonfeeding Smile
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304511 is a reply to message #304507] Wed, 05 March 2008 07:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
After that I asked my father which gave me the dictionary and teached me how to use it... seems to be hereditary. Smile

And now I know how to find the definition of ref cursor and sys_refcursor in PL/SQL guide in a couple of seconds. Smug

Regards
Michel
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304619 is a reply to message #304511] Wed, 05 March 2008 19:16 Go to previous messageGo to next message
lzfhope
Messages: 67
Registered: July 2006
Member
You are funny and humourous men. Thank you again!
Since i am not a industrious people ,but a lazy bone,so i do not want to find the answer in those books,as you know,Oracle provides us with so so many books.I beleive that you are reliable experts and would get the corrent answer.
I hope i would change what i have hone!
Laughing , Cool
Re: what is the difference between "REF CURSOR" AND "SYS_REFCUSOR" [message #304648 is a reply to message #304619] Thu, 06 March 2008 00:39 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's a useful link: Oracle Search Documentation

You will get answer to your questions in few seconds with it.

Regards
Michel
Previous Topic: Does order by slow down searches
Next Topic: [HELP] SQL complex query
Goto Forum:
  


Current Time: Sun Dec 11 04:05:23 CST 2016

Total time taken to generate the page: 0.04870 seconds