Oracle SQL Scripting: SQL
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!