Re: Quick and dirty query tool

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 04 Dec 2004 00:20:03 GMT
Message-ID: <To7sd.38097$6q2.7026_at_newssvr14.news.prodigy.com>


WQ wrote:
> Hello Folks,
>
> I was wondering if anyone can suggest a good but not too expensive Visual
> Query Tool, which will make do the following:
> 1. Build my joins by drag and drop columns between tables
> 2. Build my output clause by double clicking on displayed column list
> 3. Support native oracle functions like decode, nvl etc. (See more on this
> later).
>
> Okay, there are perhaps a lot of tools out there. I myself have evaluated a
> few and most of them were very expensive compared to my minimal needs. Two
> of them, which I frequently use are Microsoft Access and PL/SQL Query
> Reporter by All Round Automation.
>
> Here are the Pros and Cons:
>
> 1. MS Access
> Pros:
> Extremely Fast because, when you link the table using an ODBC DSN, it caches
> the data dictionery. This makes joing tables very fast.
> Cons:
> Does not support native Oracle functions like Decode, NVL etc. The SQL,
> which comes out is not formatted properly. You will et dizzy by the number
> of parenthesis it generates. Uses ODBC connections only vs ADO.
[...]

Have you tried pass-through SQL? You can create a view using Oracle native functions and then use it like other MS Access queries (views).

-Mark Bole Received on Sat Dec 04 2004 - 01:20:03 CET

Original text of this message