Re: Would be really nice if...

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