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 - Writing Executable Statements

Companies rely on the backend developers in meeting the SLAs with the customer. This course will teach you how to write efficient nested blocks and expressions using the built-in function provided by PL/SQL.

Saravanan Dhandapani - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing Executable Statements
by Saravanan Dhandapani

What you'll learn

Writing high-performing database code is one of the key ingredients to maintain and improve customer satisfaction. In this course, Writing Executable Statements, you’ll learn to apply the guidelines and recommendations offered by Oracle in structuring your PL/SQL program and writing maintainable code. First, you’ll explore the lexical units that make up a PL/SQL program. Next, you’ll discover the operator precedence in building expressions using built-in functions. Finally, you’ll learn how to write nested blocks and understand the scope and visibility of the variables. When you’re finished with this course, you’ll have the skills and knowledge of writing an effective PL/SQL program needed to create a fast performing backend.

Table of contents

About the author

Saravanan Dhandapani - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing Executable Statements
Saravanan Dhandapani

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

More Courses by Saravanan