RE: Database Query Tool

Hello Mike

You should try PlSqlDeveloper from AllAroundAutomation. A nice friendly tool that lets you create queries with GUI. No need to know SQL.
The cost was, when we bought it, was 750$ for 10 users license. I did not check reporting capabilities but a good tool for queries and updates.

See: http://www.allroundautomations.com

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Bond Mike A Contr OC-ALC/TILC [SMTP:Mike.Bond_at_tinker.af.mil]
> Sent: Tue, February 26, 2002 9:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Database Query Tool
>
> Dennis,
>
> You are absolutely correct. These users know nothing of SQL and will
> probably never be able (due to lack of interest) to do more than change
> search parameters in queries that I write and provide to them.
>
> They need access to Oracle to validate the transfer of data from IMS on
> the
> mainframe (their home planet) to Oracle. We are very sensitive to keeping
> this thing simple and may wind up creating custom forms for them to use
> (with one big button).
>
> You last comment was interesting though, but I am already on the hook to
> make the recommendation AND to train them.
>
> Thanks,
>
> Mike
>
> -----Original Message-----
> Sent: Tuesday, February 26, 2002 12:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Mike - One critical question - Will you be creating reports for the users
> or
> will they be creating the reports by themselves? We have had a lot of
> trouble where IS would buy a query or reporting tool with the idea that
> the
> users would be self-sufficient. Then it turns out that IS uses the tool.
> Actually SQL was originally created as a user query interface. How many
> users do you see today creating their own SQL statements? Sorry to be
> cynical, but we've gotten bitten on that one before. This last time IS
> stayed out of it, let the users pick their own tool, the users got the
> training and no IS people were trained. It seems to be working pretty
> good.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Tuesday, February 26, 2002 8:13 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Mike,
>
> There are a lot of tools like that on the market. My favorite for
> several
> years was Discoverer or Oracle Browser as it was then known. Recently
> though
> I've switched camps to Brio One from Brio Technology. Reason, Discoverer
> is
> part & parcel with 9IAS Enterprise & that product is an unstable pig (CPU
> &
> Disk). Had it here for a month late last year. Even the Oracle
> consultant
> could not get it installed & working. Took a long night & ton of reading
> plus
> help from OTS & then we could only get it to work on Netscape.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: Bond Mike A Contr OC-ALC/TILC <Mike.Bond_at_tinker.af.mil>
> Date: 2/25/2002 2:48 PM
>
> Hi,
> I was asked to recommend a Query Tool for some of our end users. I have
> used Q+E aka DataDirect Explorer for years. Now I can't find it on the
> internet. It has changed owners many times and may not even be available
> now.
>
> Does any one have a recommendation for a COTS product that allows the user
> with minimum knowledge of SQL to create SQL queries, views tables,
> store/recall queries, ...
>
> Is there an Oracle product that does that? Discoverer seems to be a bit
> heavy handed.
>
> Thanks,
> Mike
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bond Mike A Contr OC-ALC/TILC
> INET: Mike.Bond_at_tinker.af.mil
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bond Mike A Contr OC-ALC/TILC
> INET: Mike.Bond_at_tinker.af.mil
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).