Help - Oracle Designer SQL Plus export Attribute Descriptions and Notes

From: TRI3 <tri3_at_onebox.com>
Date: 12 Apr 2002 06:17:21 -0700
Message-ID: <82d2b910.0204120517.48cdda3d_at_posting.google.com>


I am working on a project that is using Oracle Designer. The reports that Oracle Designer generates are less than what I was hoping for. The reports contain way too much information and are way too long to be of any use for documentation.

What I would like to be able to produce is a report that displays the Table Name, Field Name, Field Type, Field Length, Required Field, Field Description (What Oracle Designer calls Attribute Description), and the Attribute Notes Field.

Currently I am able to get everything except the Attribute Description and Attribute Notes using SQL Plus and the following SQL Statement.

select rpad(table_name,30) as tn,
  2 rpad(column_name,30) as cn,
  3 rpad(data_type,10) as dt,
  4 data_length
  5 from all_tab_columns
  6 where table_name like 'ATT%'
  7 order by table_name,column_name;

Any help would be greatly appreciated.

Thanks Received on Fri Apr 12 2002 - 15:17:21 CEST

Original text of this message