Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Use Explicit Cursors

Companies rely on backend developers in meeting SLAs with the customer. This course will teach you the different cursor types and how to leverage them in fetching data involving concurrent sessions.

Saravanan Dhandapani - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Use Explicit Cursors
by Saravanan Dhandapani

What you'll learn

Writing consistent and predictable database code is one of the key ingredients to maintain and improve customer satisfaction. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Use Explicit Cursors, you’ll learn to leverage PL/SQL cursors to effectively fetch data from the database. First, you’ll explore the various cursor types supported by PL/SQL and the business cases where they can be used. Next, you’ll discover how to pass parameters and use built-in cursor attributes. Then, you'll delve into how to use a FOR loop cursor in fetching data. Finally, you’ll learn how to use cursors when you have multiple sessions opened against the same set of rows. When you’re finished with this course, you’ll have the skills and knowledge of effectively using cursors needed to create fast-performing, consistent, and predictable PL/SQL code.

Table of contents

About the author

Saravanan Dhandapani - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Use Explicit Cursors
Saravanan Dhandapani

I have been passionate about designing and developing software that is scalable, portable and maintainable.

More Courses by Saravanan