Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Would be really nice if...

Re: Would be really nice if...

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 24 Feb 2005 07:52:18 -0500
Message-ID: <>

"Ed Stevens" <nospam_at_noway.nohow> wrote in message
> On Thu, 24 Feb 2005 03:05:17 GMT, "Haximus" <> wrote:
>>> Oracle's heirarchical queries predated most of the standards. It would
>>> be
>>> silly for them to retract something after it's become popular.
>>If you rely on such features and develop products with multi-vendor
>>in mind it's not a trivial thing, though I definitely prefer Oracle's
>>to the standard way. I also prefer not to have to type select lists of 97
>>columns for a table that has 98... you can call me lazy, for that matter
>>perhaps we should go back to keeping records on clay tablets, because all
>>this modern technology stuff is really just rewarding the 'lazy' ;)
> Who types up 97 column names in a select statement? Spool a DESC
> MYTABLE, then open up the spooled file with your favorite editor and
> do a few quick edit commnds to format the list into a SELECT
> statement. Snip, paste, done -- with no chance of a typo to boot.
> Thanks.
> - Ed Stevens
> Cohn's Law: The more time you spend in reporting on what you are doing,
> the less time you have to do anything. Stability is achieved when you
> spend all your time doing nothing but reporting on the nothing you are
> doing.

Cohn's Law #2: The more time you spend posting arguments and counterarguments on saving time, the less time you have to do what you think takes too long to do. Insanity is acheived when you get the rest of the community to spend all their time doing doing nothing but posting.

Don't you guys have some long column lists you need to get back to typing?


++ mcs Received on Thu Feb 24 2005 - 06:52:18 CST

Original text of this message