Re: oracle schema 'navigation'

From: <sybrandb_at_hccnet.nl>
Date: Thu, 29 Mar 2007 23:31:43 +0200
Message-ID: <qubo03dlptvagedu4uqkek2vm6k46d8l4m_at_4ax.com>


[Quoted] On 29 Mar 2007 13:15:44 -0700, "dave" <dave8421_at_hotmail.com> wrote:

>Hi,
>
>I'm quite new to using databases, and have working knowledge of SQL.
>
>Are there any GUI/visual tools available that would quickly show me
>what foreign key / primary keys are defined on tables?

you don't need a GUI

set long 1000000
[Quoted] select dbms_meta_data.get_ddl('TABLE',<tablename>,<schema>) from dual;

and you are there.

You are aware of Sql Developer, from Oracle? Can be downloaded from http://otn.oracle.com for free.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Mar 29 2007 - 23:31:43 CEST

Original text of this message