DDL Generation--Oracle's Answer to Save You Time and Money - Page 3
May 1, 2003
Supported Object Types
Here is a glimpse of the supported object types that can be input to the two previous function calls. Look at the Oracle documentation to determine the granularity you can achieve.
Where To Go From Here
The direction that Oracle has gone is a good one. I really love these function calls. You should research and see where it fits into your organization. The one item I do think is missing is the ability to generate a full DDL map for an object. I personally would like to execute just one function and be able to get not only the table DDL, but also all the constraints, indexes, grants, and so on associated with the table without having to execute for each and every object type that might make up the table in question. When Oracle does this, we will truly have a powerful solution to DDL extraction and be able to, with precision and confidence, do maintenance on any part of an object within Oracle.