Re: MS SQL Server like Query Builder??

what does being able to construct a sql query using both a gui and text entry at the same time have to do with Windows-centric? I am happy to have someone suggest a tool that runs only on linux if it enables me to quickly create a sql query as well as add complexity that a gui alone might not be able to provide (or do so in an awkward manner).

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news: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
>
> 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 Sun Oct 24 2004 - 04:21:19 CEST