What you'll learn

It is important to design your PL/SQL code to optimize execution, follow standard conventions, and be secure. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Design Considerations for PL/SQL Code, you will learn about some useful database features and best practices that will help you better design your PL/SQL code. First, you will learn how to create local subprograms, what limits the scope of where they can be used, and standard constants and exceptions which keep your code consistent and easy to maintain. Next, you will see how to control the run-time privileges of a subprogram to enhance your application’s security, and understand the uses and implications of nocopy, parallel enable hints, and deterministic clauses. Then, you will look at bulk binding and returning clauses with DML statements, which can significantly help improve the performance of your code. Finally, you will explore autonomous transactions, which allow Oracle to suspend the current transaction and initiate a fully independent transaction - a very useful feature for use cases like logging. When you’re finished with this course, you’ll have the skills and knowledge to effectively design your PL/SQL code, which can help you ace that section of the exam - 1Z0-149: Oracle Database Program with PL/SQL.