HomeОбразованиеRelated VideosMore From: Manish Sharma

PL/SQL tutorial 69: PL/SQL Strong Ref Cursor with User Defined Record Datatype in Oracle Database

171 ratings | 7349 views
RebellionRider.com presents PL/SQL Strong Ref Cursor in Oracle Database. In this tutorial, you will learn how to create a Strong Ref Cursor using User-Defined record datatype variable. Enjoy! ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-3 Previous Tutorial ►Strong Ref Cursor with Table based Record https://youtu.be/6fTdB_cMS6o ► Anchored Datatype https://youtu.be/Zt0vlmTqhP4 ►User Defined Record https://youtu.be/sy6H2ZLoZwg ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (6)
Chaitra Muniyappa (1 day ago)
in returning user defined type for the return variable i am using data type as newly created type but it gives error .. why is it ? declare type my_type is record (emp employee.name%type); type cu is ref cursor return my_type; c cu; retu my_type; -- doesnt work gives error wrong number or types of arguments in call to -- retu employee.name%type; ---this works begin open c for select name from employee where id=3; fetch c into retu; close c; dbms_output.put_line('employee of id 3 : ' || retu ); end; /
Rahul Panari (1 year ago)
Manish sir, awesome, outstanding,mind blowing
Usman Siddique (1 year ago)
GOD give you success and long life Thank You
steven macdonald (1 year ago)
Manish, love your tutorials, dont stop doing them..Brilliant
Rohmat Suryanto (1 year ago)
thank you manish for whole tutorial so far
Fiaz Mohd (1 year ago)
keep up the good work 👍

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.