Hi Friends,
Here we learning about REF CURSOR in Procedure. How to OPEN CURSOR in one procedure and FETCH data in another procedure.
Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box.
Link (REF CURSOR Introduction, Strong Ref Cursor, Weak Ref Cursor, Sys_RefCursor) :
https://youtu.be/myajCnmO1n4
Link (REF CURSOR Example || CURSOR with two different Select Statements) :
https://youtu.be/5MwvkYtFbgQ
Link (Cursor FOR LOOP with parameter) :
https://youtu.be/AwrcCS0CmGU
Link (Cursor FOR LOOP) :
https://youtu.be/Y_W97kwSiJo
Link (Cursor Parameter with default value) :
https://youtu.be/YvLN8xum8TQ
Link (How to pass parameter in CURSOR) :
https://youtu.be/qYQr7oBHvxY
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
About Me :
https://about.me/saurabhsagarsinha
Thanks.
Happy Coding :)
