Re: User Friendly Front-End Client for Oracle 8?

I use SQL-station. It gives a view similar to Windows Explorer. It shows all schemas as folders which contain several items inside (Tables, Views, Synonyms, etc) which can be further expanded to show all individual items. In addition to this you can type in and save queries. You can open a table and edit the data directly instead of writing DML statements (the interface just displays the table as a spreadsheet).

A really cool feature of Platinum's SQL-station is the query optimizer (I believe it costs extra). You can write several queries and have SQL-station analyze different aspects of the queries, including the relative costs, the number of reads and writes, CPU time... Then it will give you a side-by-side comparison of how each query performed.

I beleive they have a 30 day demo, but I don't have the address for it :-(

-Peter

On Wed, 17 May 2000, Matt B. wrote:

> "David" <David_at_macraild-circus.demon.co.uk> wrote in message
> news:o96UgCAf5WI5EwbM_at_macraild-circus.demon.co.uk...
> > Hi all,
> >
> > I wonder if anybody can help. I have recently started to work with
> > Oracle 8 having used MS Access for the past couple of years. Obviously
> > there is a learning curve here, but one thing I can't get over is that I
> > need to create everything using SQL queries (via SQL*Plus and/or ODBC
> > Test). This is OK, but I'm having a problem with the idea that I can't
> > see everything at any one time (e.g. switching to 'Design' view).
> >
> > The question is - am I missing something? E.g. is there an Oracle client
> > that allows me to view all my tables, their data, constraints etc, or is
> > it possible to use an app such as Access as a front -end to Oracle 8i?a
> >
> > All input gratefully received.
> > --
> > David
>
> TOAD is pretty good.
>
> http://www.toadsoft.com
>
> Download a free trial copy (expires after a while though).
>
> I've also heard of something called SQL Station too, but I'm not sure how good
> the user interface is (haven't used it myself but others have liked it).
>
> -Matt
>
>
>
Received on Wed May 17 2000 - 00:00:00 CEST