Re: Newbie Questions
Date: Thu, 15 Aug 2002 07:41:57 +0000 (UTC)
Message-ID: <3d5b5bea.878773_at_news.btclick.com>
>Thanks for the info. I'm looking for the best of both worlds. I like
>to use the command line mode for banging out queries. But I have
>terrible short term memory! I like to be able to see the objects in a
>tree (e.g. table names, field names, etc). Otherwise, If I forget
>something, I'm back at the command prompt to enter another query to
>get the name of a column, for instance. I find that OEM is good for
>many things. However, I find it cumbersome in that you can't pull up
>details on a table and get to Constraints, Triggers, and Indexes from
>that one place. You have to navigate different parts of the tree to
>see indexes or triggers, for instance.
You could use the DDL to HTML coverter in the freeware DBATool to create a web tree of the schema you are interested in. Then you would have all of the structure information available in your browser as you "bang out" the SQL at the SQLPlus prompt. The information is all automatically cross indexed so that the page that displays the table DDL also contains links to the indexes, foreign keys, synonyms etc for the table.
DBATool: http://www.DataBee.com/dt_home.htm
Regards
Dale Edgar
DataBee: Create referentially correct small versions of large Oracle databases for development and test. http://www.DataBee.com Received on Thu Aug 15 2002 - 09:41:57 CEST