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

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

Re: Would be really nice if...

From: <pobox002_at_bebub.com>
Date: 25 Feb 2005 04:18:22 -0800
Message-ID: <1109333902.754276.46980@f14g2000cwb.googlegroups.com>

Haximus wrote:
> "Ed Stevens" <nospam_at_noway.nohow> wrote in message
> news:ovhr115c65eng26rgku4fn61efujk66v2v_at_4ax.com...
> > On Thu, 24 Feb 2005 03:05:17 GMT, "Haximus" <e_at_t.me> 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

> >>support
> >>in mind it's not a trivial thing, though I definitely prefer
Oracle's
> >>syntax
> >>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.
>
> A good option but I do it with java... I use the metadata to script
together
> select lists with my homemade utility, I really hate repetitive
typing. I
> recently had a case where I had to create a number of views,
substituting
> just one column from other tables. The exclude option would have
been
> great.

So you have limitations in your tool of choice and way of doing things that no one else seems to have and as a result of the difficulties that only you appear to suffer you want to change the SQL standard.

Pardon me if I don't commiserate.

-- 
MJB
Received on Fri Feb 25 2005 - 06:18:22 CST

Original text of this message

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