Re: suggestions for good graphical DB query builder

In the same way that First and Last is somewhat difficult in Oracle no 
doubt.

Not that I defend Access but frankly I think you need to wake up and
realise 
that a significant number of people don't use oracle.

-- 
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]


"DA Morgan" <damorgan@[EMAIL PROTECTED]
> wrote in message 
news:1190227016.710277@[EMAIL PROTECTED]
> David Segall wrote:
>> DA Morgan <damorgan@[EMAIL PROTECTED]
> wrote:
>>
>>> David Segall wrote:
>>>> carol_marra@[EMAIL PROTECTED]
 wrote:
>>>>
>>>>> We're doing a product comparison for graphical query builders. Would
>>>>> appreciate
>>>>> your input on what you like (or don't).
>>>>>
>>>>> We're an Oracle shop, but we need connectivity w/ any ODBC compliant
>>>>> DB.
>>>>> Also need query result ex****t options (esp Excel), pivot capability,
>>>>> printable results,
>>>>> Windows compliant.
>>>> Microsoft Access?
>>> I can't think of a worse tool.
>>>
>>> The last thing Oracle needs is to be connected to an insecure (ODBC)
>>> tool that could potentially be used to alter data
>> In that case you need to secure the Oracle database since almost
>> everybody has Access on their desktop.
>>> and in which you
>>> couln't write a decent SQL statement more complex than SELECT *
>>>FROM t;.
>> There are limits to the SQL that can be composed using the graphical
>> query builder but I doubt if anybody who would deign to use a
>> graphical tool would reach them. If by "decent" you are referring to
>> the generated SQL I have no way of comparing it to your other
>> contenders. I confess that I have felt the need to simplify Access
>> generated SQL when I have used it in a program that somebody else
>> might have to modify.
>
> Referring to the fact that the following query would be impossible
> to write:
>
> WITH  w AS (
>   SELECT person_id
>   FROM person
>   WHERE per_fmw = 'Y')
> SELECT per_h_email
> FROM person p, w
> WHERE p.person_id = w.person_id
> AND p.per_ok2_email = 'A'
> AND p.per_h_email IS NOT NULL
> UNION
> SELECT po_w_email
> FROM poie o, w
> WHERE o.person_id = w.person_id
> AND o.po_status = 'A'
> AND o.po_w_email IS NOT NULL;
>
> I would write dozens of other basic statements impossible to
> duplicate in MS Excess.
> -- 
> Daniel A. Morgan
> University of Wa****ngton
> damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org