Re: MS SQL Server like Query Builder??

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 22 Oct 2004 18:08:21 -0700
Message-ID: <1098493647.725643_at_yasure>


Dan wrote:

> Hi,
>
> I am looking for a graphical query builder tool native to Oracle database
> that replicates the functionality built into MS SQL Server Enterprise
> Manager. To those unfamiliar it allows both graphical and text editing of
> a sql statement when creating a view or ad-hoc query. For example I might
> graphically select 2 tables and use the GUI to create a join. It displays
> the actual SQL statement below and I could modify the SQL text and have it
> be reflected in the GUI for the most part. OR I could take an existing SQL
> statement and paste it into the tool, and it loads it into the GUI part.
>
> I have downloaded many Oracle centric tools including TOAD, SQL Navigator,
> Rapid SQL etc etc and while they have a graphical SQL Modeler, they do not
> allow you to start with sql text or subsequent editing in the SQL text to be
> reflected in the model.
>
> Regards

[Quoted] Not possible unless the point of the exercise is to be, as is SQL Server, Windows-centric which, thank the gods, Oracle is not.

Take a look at Oracle Discoverer ... a good product for the technically challenged.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Oct 23 2004 - 03:08:21 CEST

Original text of this message