Re: MS SQL Server like Query Builder??

[Quoted] At the risk of incurring Daniel Morgan's wrath, I'll mention my product Advanced Query Tool at http://www.querytool.com/

It does much what you are wanting; you can build a query in either graphical mode or SQL mode. If you have an existing SQL query, you can display it in the graphical query builder (I haven't seen many other products with this latter capability).

Phil Castle.

"Dan" <nospamwanted_at_sorrynospamwanted.com> wrote in message news:<P%8ed.316639$bp1.244518_at_twister.nyroc.rr.com>...
> 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
Received on Sun Oct 24 2004 - 11:17:14 CEST