Help - Oracle Designer SQL Plus export Attribute Descriptions and Notes
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