Reference cursor in SQL

Question

What is reference cursor in SQL?

Satyapriya Nayak · Answer

http://www.java2s.com/Code/Oracle/Cursor/Defineandusereferencecursor.htm

Shankar M · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} Hi Sharad, A Ref cursor is just a pointer to the result set of the cursor with which it is associated.

Satyapriya Nayak · Answer

http://www.devshed.com/c/a/Oracle/Working-with-REF-CURSOR-in-PL-SQL/ http://msdn.microsoft.com/en-us/library/4s2zbbsz%28v=vs.80%29.aspx

Reference cursor in SQL

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)