Re: Newbie Questions

On Thu, 15 Aug 2002 07:41:57 +0000 (UTC), Dale_at_DataBee.com (Dale Edgar) wrote:

>
>
>>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

Great idea, Dale. Thanks. Received on Thu Aug 15 2002 - 09:50:30 CEST