What you'll learn

It is important to write high-quality PL/SQL code, but it is equally important to manage it effectively - to ensure it functions per our requirements. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code, you’ll learn how to conditionally execute your PL/SQL code, which is useful for debugging and testing as well as providing database-version-specific features. First, you'll discover how to achieve fine-grained access control using the code based access control feature of Oracle PL/SQL. Next, you'll explore the ACCESSIBLE BY clause which is used to whitelist access to the subprograms by other PL/SQL units. Finally, you'll understand how to deprecate pieces of PL/SQL code, to indicate that the program unit is still valid but is now superseded by a better option. When you’re finished with this course, you’ll have the skills and knowledge to effectively manage your PL/SQL code, which can help you ace the Managing PL/SQL Code section of the Oracle Database Program with PL/SQL exam number: 1Z0-149.