On 6/8/07, Peter Scott <[EMAIL PROTECTED]> wrote:
The suggestion of another poster to use dbms_metadata (see, e.g. http://builder.com.com/5100-6388-5054021.html) was a good one; I'd not heard of it before. If I have to do more than just column type definitions, or multiple tables, in the future, I'll definitely check it out.
dbms_metadata has one nasty flaw - the output must be manually reformatted to be usable. Try using DDL::Oracle, as it does work. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist