
Use an Oracle API to Extract and Store Database Objects’ DDL
here are times when database data manipulation requires extracting DDL (Data Definition Language) commands for various objects, such as database tables, indexes, constraints, triggers, etc. Recently I was charged with the task of writing a set of database packages to perform a high-performance massive DELETE operation. While my high-performance massive