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.
Author Name: Saravanan Dhandapani
Author Description:
I have worked in IT design, development, and architecture for over a decade for some of the top fortune 100 companies. I have designed and architected enterprise applications and developed scalable and portable software. I am a Google Certified Professional Architect. Critical areas where I have worked are architecture and design using Java, ESB, Tomcat, ReactJS, JavaScript, Linux, Oracle, SVN, GIT, and so on, and cloud technologies, including AWS and GCP.