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.
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.
Table of contents
About the author
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.