Re: Oracle complex SQL query development tools?

In article <ExMrr7.1p5_at_ig.co.uk>,
  Jacqui.Caren_at_ig.co.uk (Jacqui Caren) (Jacqui Caren) wrote:
> I have been looking for a few weeks for a tool to
> assist one of our developers in the construction
> of large multi table select queries. I have to
> admit total defeat here :-(. I found some tools
> but none of any quality or "fitness-for-purpose".
>
> Overview
> --------
> The developer makes extensive use of decode etc
> and (select) queries often fall into the 1000's
> of lines. He spends a large amount of time
> manually designing these and a (good) tool to
> allow rapid design and modification of complex
> queries would produce a reduction in his stress
> levels - which would be good for all :-)
>
> Commercial and free/shareware suggestions are
> both appreciated. Please don't tell me that such
> large complex queries are bad practise
> - the size and complexity of the queries are
> due to application realm (large complex
> reports against telecoms call/billing data).
> - I am the wrong person to try and convince :-)
>
> If I find nothing of value I will probably end up
> writing something in perl/DBI/tk - based on prior
> developed software, but this would be a act of
> last resort...
>
> Thanks,
> Jacqui
>
> p.s.
> If people respond by email I will summarise
> back to this group...

If you are, I might as well answer here:

try ftp.frigate.com directory pub/dbsurfer : free eval till Sept 30/98

Email me for password when you get it.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 19 1998 - 22:38:26 CEST