Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code

This course will help you acquire certification for the Oracle Database Program with PL/SQL exam number: 1Z0-149. It will cover the exam objectives of managing PL/SQL code in the Oracle database.

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.

• Course Overview 1min
• Introduction 6mins
• Describe and Use Conditional Compilation 31mins
• Code Based Access Control 17mins
• Whitelist Code Access with the ACCESSIBLE BY Clause 11mins
• Mark Code as Deprecated 18mins