Re: Best Oracle front end / Query tool for power users

On Mar 27, 7:52 am, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> "joel garry" <joel-ga..._at_home.com> wrote in message
>
> news:1174694571.630562.227010_at_e65g2000hsc.googlegroups.com...
>
> > On Mar 22, 2:57 pm, "AlterEgo" <altereg..._at_dslextreme.com> wrote:
> >> Terry,
>
> >> Don't forget Excel, which is probably more widely used than Access. The
> >> visual query tool is good for novices and the SQL view provides more
> >> capabilities for power users.
>
> >> -- Bill
>
> > Soooooo... what happens when they look at my 10 million row inventory
> > table? I bet it will blow up at row 65331. Hope they don't try
> > joins...
>
> > Note that I'm using tools every day to load up Excel spreadsheets for
> > people who aren't capable of the visual query tool, somehow that
> > enhances my pre-existing bigotry against it.
>
> > jg
> > --
> > @home.com is bogus.
> > XML is indeed bad for performance:
> >http://www.sqlsnippets.com/en/topic-11783.html
>
> Excel 2007 doesn't have that limit anymore. Now would I want to do anything
> in Excel with that many rows ...?

Well, I have to look at it the other way, what limits does Excel 2007 have? So I googled for the minimum system requirements, first hit is an ms page, click on it, XP blocks ms from downloading a dll... anyways, the environments I work in aren't generally up to XP yet. Yes, Excel in general is close to ubiquitous, but then again, so are tetanus spores. But it's easier to innoculate against tetanus than the bad stuff ms software does. I'm sorry, every couple of years I try to give ms software a fair shake, and every couple of years I find once again, it's bad mojo. In the near future I'll be handling the Oracle (and ERP) side of a big upgrade to XP, because the ERP vendor requires it in order to continue to use one of their older architectures (would be a wtf, except they appear to be hacking some security fixes onto it doing it that way). But I can predict it easily - yes, they will be trying to do things in Excel with that many rows, not be able to do it, hack up some bogus solution, not be able to do that either, then ask me to implement their bogus solution through proper code. In other words, giving these inappropriate tools to those who can't design properly demonstrates in expensive terms why Bill's "tool agnosticism" turns into a bad thing. The whole PC paradigm was geared towards having a bunch of executives each having their own numbers in their own spreadsheets, with fallout that spans generations.

jg

--
@home.com is bogus.
"... visions of empire arose before Joel's eyes..." - Isaac Asimov