If you are an Oracle professional working on database development or database administration, this book is for you! It will demonstrate the techniques to write SQL scripts, automate a myriad of database tasks, boost your productivity, and have fun writing those scripts at the same time! This will save you time for repetitive tasks. This is a very unique book on this subject.
This eBook has 15 chapters. It will help you exploit the power of DBMS_METADATA package to extract DDL for all objects, help you reset sequences, extract the grants, revoke the grants, compile invalid objects, mask sensitive data, drop all schema objects, enable/disable constraints, rebuild indexes, index foreign keys, write triggers for generic auditing and much more!
Hope you enjoy this eBook!
This eBook has 15 chapters. It will help you exploit the power of DBMS_METADATA package to extract DDL for all objects, help you reset sequences, extract the grants, revoke the grants, compile invalid objects, mask sensitive data, drop all schema objects, enable/disable constraints, rebuild indexes, index foreign keys, write triggers for generic auditing and much more!
Hope you enjoy this eBook!
