Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: suggestions for good graphical DB query builder

Re: suggestions for good graphical DB query builder

From: David Segall <david_at_address.invalid>
Date: Sat, 22 Sep 2007 07:17:35 GMT
Message-ID: <o8f9f3h44d38jomde9mnsva6rkbruj2e8k@4ax.com>


DA Morgan <damorgan_at_psoug.org> wrote:

>>>> carol_marra_at_msn.com wrote:
>>>>
>>>>> 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.

>>> I can't think of a worse tool [than Microsoft Access].
>
>Referring to the fact that the following query would be impossible
>to write:

I resile completely. Please post the name of the graphical DB query builder that meets the OP's specification and that you [could] have used to write the query.
>
>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.
Received on Sat Sep 22 2007 - 02:17:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US