Re: suggestions for good graphical DB query builder

[Quoted] 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_at_psoug.org> wrote in message 
news:1190227016.710277_at_bubbleator.drizzle.com...


> David Segall wrote:


>> DA Morgan <damorgan_at_psoug.org> wrote:
>>
>>> David Segall wrote:
[Quoted] >>>> carol_marra_at_msn.com wrote:
>>>>
[Quoted] [Quoted] >>>>> We're doing a product comparison for graphical query builders. Would
>>>>> appreciate
[Quoted] >>>>> 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 export 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 Washington

> damorgan_at_x.washington.edu (replace x with u to respond)

> Puget Sound Oracle Users Group

> www.psoug.org