Re: Any shareware/gnu ER diagramers out there?

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Thu, 13 Sep 2001 07:19:32 -0700
Message-ID: <F001.0038D18A.20010913062522@fatcity.com>

!! Please do not post Off Topic to this List !!

Not sure this is what you want.

Joan

set pagesize 24
set linesize 132

col fk_owner format a10
col fk_table format a15
col pk_owner format a10
col pk_table format a15
col fk_col format a15
col pk_col format a15
select fk.owner fk_owner,
        fk.table_name fk_table,
        fkc.column_name fk_col,
        pk.owner pk_owner,
        pk.table_name pk_table,
        pkc.column_name pk_col
from dba_constraints fk, dba_constraints pk,dba_cons_columns fkc,
        dba_cons_columns pkc

where fk.r_constraint_name = pk.constraint_name

and fk.constraint_type = 'R'
and pk.constraint_type='P'
and fk.r_owner=pk.owner
and fk.constraint_name=fkc.constraint_name
and pk.constraint_name=pkc.constraint_name
and fk.owner=fkc.owner
and fk.table_name =fkc.table_name
and pk.owner=pkc.owner
and pk.table_name=pkc.table_name
and pk.owner not in('SYS','SYSTEM')

/

> "Koivu, Lisa" wrote:
>
> Toad. www.toadsoft.com
> Does everything you're asking for.
>
> Lisa Koivu
> Oracle Database Administrator
> Fairfield Resorts, Inc.
> 954-935-4117
>
> -----Original Message-----
> From: John Lewis [SMTP:jlewis_at_punchnetworks.com]
> Sent: Wednesday, September 12, 2001 1:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Any shareware/gnu ER diagramers out there?
>
> Basically looking for something that reads a schema and prints
> out
> what tables have FK to what other tables. Dependencies also?
>
> I may have a need very soon for one.
>
> Thanks -
>
> John F. Lewis
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Lewis
> INET: jlewis_at_punchnetworks.com
>
> 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: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

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 Thu Sep 13 2001 - 09:19:32 CDT