PL/SQL tutorial 67: PL/SQL Ref Cursors In Oracle Database by Manish Sharma

Key Takeaways

Musab internet i am manish from rebellionrider.com and i am back once again with another PL sequel tutorial in today's tutorial we will learn what PL sequel ref cursors are in Oracle database a little bit knowledge of database cursors will be required for the better understanding of this tutorial fortunately we already have a series covering the concepts of cursors you can find that the link as always is in the description I suggest you to watch those tutorials so without further wasting your time let's start this PL sequel tutorial and learn what are ref cursors in Oracle database ref cursor is an acronym of reference to occur so it is a PL sequel datatype using which you can declare a special type of variable called cursor variable unlike static cursors which we have already discussed on this channel a single cursor variable can be associated with multiple select statements in a single PL sequel block on the other hand a static cursor can only access single select statement at a time cursor variables and ref cursors are two interdependent topics so do not get confused with them just take them as in Oracle database cursor variables exist in the form of ref cursors let's go ahead and see how many types of ref cursors we have in Oracle database there are two types of ref curses in Oracle database these are strong ref cursors and we graph cursors strong ref cursors any ref cursor which has fixed return type is called strong ref cursor let's see the syntax of a strong ref cursor and here it is the return type of a cursor must always be of record type only it can either be a record structure of a table or a user-defined record structure you can refer PL sequel tutorial 40 41 and 42 to learn more about record datatypes in Oracle database weak ref cursors in contrast to strong ref cursors weak ref cursors are those which do not have any return type in simple words those ref cursors which do not have fixed return type are called V Kraft cursors such cursors are most frequently used for F cursors as they are open to all select statements whereas strong ref cursors can only be used with those select statements that returns the result whose data type matches with the one that you have fixed during the strong cursors declaration let's take a look at the syntax of we craft cursors in Oracle database except from the missing written clause the syntax is pretty much similar to the strong graph cursors apart from strong and we graph cursors Oracle database also provides us with one more type of special cursor variable before talking about that I just want to take a quick second to ask you to give this video a thumbs up and if you are new here then do make sure to subscribe you can also help others in learning as well as help us and our channel in growing by sharing this video on your social media thanks now let's come back to our topic so we are talking about that special cursor variable provided by or a it is known by the name of sis RAF cursor since RAF cursor is an oracle built-in cursor variable it declares a week RAF cursor and dad too without declaring the RAF pointer type we will see what that means when we will do a separate video on sis RAF cursor till then stay tuned and do subscribe because in upcoming videos we will do the examples of strong and V Graf courses as well as sis RAF courses also to make sure to like and share this video this is a quick introduction to PL sequel RAF cursors / cursor variable in Oracle database thanks for watching this is Manish from rebellion trader.com