RE: Create info about table definition

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 25 Mar 2002 03:48:20 -0800
Message-ID: <F001.00431CFD.20020325034820@fatcity.com>

To start with, you could look at DBA_TAB_COLUMNS:

select table_name,

       column_name,
       data_type

  from dba_tab_columns
 where owner = 'SCHEMA_OWNER';

or

select table_name,

       column_name,
       data_type

  from dba_tab_columns
 where table_name = 'TABLE_NAME';

Create your table:

CREATE TABLE TAB_COLUMNS
(

    TABLE_NAME VARCHAR2(30) NOT NULL ,
    COLUMN_NAME VARCHAR2(30) NOT NULL ,     DATA_TYPE VARCHAR2(106)
);

and simply:

insert into TAB_COLUMNS (select table_name,

                                column_name,
                                data_type
                           from dba_tab_columns
                          where table_name = 'TABLE_NAME');

What do you actually want to do this for?

<SHAMELESS PLUG>

If this is to "document", I have a far easier way of "documenting" the DDL, and dependencies for tables/objects within a schema, and yes it is with a tool, but it's a free tool, so I don't feel too shameful about plugging it! ;)

Check out:

http://www.cool-tools.co.uk/Products/dbatool.html

Take an export with rows=n of your schema, feed it in to the tool, and generate yourself a nice set of html files that will show you the structure of the tables/objects, and all dependencies on that object. All you have to do then is load the html files to an intranet or something.. This also has an added benefit in that the whole process (apart from the actual export) is totally unobtrusive to the database.

</SHAMELESS PLUG> ;)

HTH Mark

---

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----
Roland.Skoldblom_at_ica.se
Sent: 25 March 2002 10:53
To: Multiple recipients of list ORACLE-L

Hallo,

is there any way to create a table of the definition of table( list of field names and their datatypes, indexes etc)

Thanks in advance

Roland S

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Mar 25 2002 - 05:48:20 CST