Oracle Database Tutorials

PL/SQL Tutorials for Beginners

PL/SQL Tutorial list



PL/SQL Tutorial 61:- Collection Methods FIRST ( ) & LAST ( ) in Oracle Database

Welcome back once again to the series on Collection Methods in Oracle Database. So far in this series we have covered Collection Function Count ( ) and Collection Function Exist ( ). Hope you enjoyed reading. Today in this PL/SQL tutorial we will learn collection methods First ( ) and Last ( ).


PL/SQL Tutorial 62:- Collection Methods LIMIT in Oracle Database

Today’s PL/SQL tutorial is all about Collection Method LIMIT. We have already seen 4 functions in this collection method series that are – Count, Exists, First and Last. Limit is the fifth function which we will be learning today.


PL/SQL Tutorial 63:- Collection Methods Prior and Next in Oracle Database

It is always good to have some functions under your sleeve which can help you in navigating through the content of your collection. The function Prior & Next could be those functions.


PL/SQL Tutorial 64:- Collection Methods Delete in Oracle Database

As discussed in the Introduction to collection methods we have seven collection functions and 3 collection procedures. Therefore in total we have 10 collection methods among which we have already discussed 7 collection functions so far.


PL/SQL Tutorial 65:- Collection Methods EXTEND in Oracle Database

As discussed in the Introduction to collection methods we have seven collection functions and 3 collection procedures. Therefore in total we have 10 collection methods among which we have already discussed 7 collection functions so far.


PL/SQL Tutorial 66:- Collection Methods TRIM in Oracle Database

Welcome back to the last tutorial in the PL/SQL Collection series. The longest video tutorial series so far on the channel. In this tutorial we will learn about the last PL/SQL Collection procedure which is TRIM.


PL/SQL Tutorial 67:- Introduction to PL/SQL Ref Cursor

When it comes to performance, Ref Cursors have always proven themselves superior to static cursors.


PL/SQL Tutorial 68:- PL/SQL Strong Ref Cursor with Table Based Record Datatype

learn What is PL/SQL Strong Ref Cursor in Oracle Database and how to create it using table based record datatype.


PL/SQL Tutorial 69:- PL/SQL Strong Ref Cursor with User Defined Record Datatype

learn What is PL/SQL Strong Ref Cursor in Oracle Database and how to create it using User-defined record datatype.


PL/SQL Tutorial 70:- PL/SQL Weak Ref Cursor in Oracle Database

learn What is PL/SQL Weak Ref Cursor in Oracle Database.





  • Manish Sharma Oracle Rebellion Rider
  • Manish Sharma Oracle certified SQL expert
  • Manish Sharma oracle certified associate
  • Manish Sharma oracle certified professional
  • View Manish Sharma's profile on LinkedIn

         View Manish Sharma's profile on LinkedIn