Re: Data Browser

In article <1ttrojINN6fb_at_cronkite.cisco.com> pkane_at_cisco.com (Peter Kane) writes:

> Path: oracle!gatekeeper.us.oracle.com!decwrl!decwrl!elroy.jpl.nasa.gov!ames!cronkite.cisco.com!pkane
> From: pkane_at_cisco.com (Peter Kane)
> Newsgroups: comp.databases.oracle
> Date: 25 May 1993 19:24:03 GMT
> Organization: cisco Systems, Inc.; Menlo Park, California 94025
> Lines: 21
> References: <sjsC7LDvI.AnH_at_netcom.com>
> NNTP-Posting-Host: diablo.cisco.com
>
> In article <sjsC7LDvI.AnH_at_netcom.com> sjs_at_netcom.com (Stephen Schow) writes:
> >Anyone use Oracle Data Browser yet....especially for the mac? Its 600 bucks
> >plus more for the support. Anyone have any strong reasons for paying more
> >for this when there are 3rd party software products that are half that price?
>
> I've used the Beta version of Oracle Data Browser for the Mac. Which is
> why I no longer do.
> The way it dumps data into a spreadsheet-like format is nice, especially
> the way you can format the output. However, the way you have to select
> datasources, link selected tables (right, it won't do it for you) and
> formulate the where clause is less than fun. Not for the computer
> phobic user. The worst part of it is its reliance on SQL*Net. It can't
> work in the background, so your Mac is frozen until the data comes back
> from the query. Try telling your user they're not going to be able to
> use their machine for 10 minutes, if it is a big query. Oracle support
> says no solution any time soon. The windows market is much more
> appealing to them....
>
> Peter
> pkane_at_cisco.com

Selected tables are automatically joined if the tables were created with constraint information. If no constraint information is in the data dictionary, then you have to manually create the links (after which they will be automatically enabled or disabled depending on your query).

Also, simple where clauses can be automatically generated from the spreadsheet-like interface. The useful part of this is that you do not need to know the difference between where and having conditions. Oracle Data Browser automatically takes care of them.

Freezing your machine on big queries is because of the dependency on SQL*Net. This happens also on Windows. This issue is being addressed by ORACLE7 Version 7.1 and SQL*Net V2.1. Are there any ad-hoc query tools that work against Oracle in the background on the Mac?

-girish Received on Wed May 26 1993 - 20:33:56 CEST