Re: Would be really nice if...

mikharakiri_nospaum_at_yahoo.com wrote:
> Haximus wrote:
> > ...if there was a select_list:: feature to do wildcard selects on
> columns,
> > then EXCLUDE specified columns, e.g.:
> >
> > SELECT * EXCEPT UNIT_NO, ETC, ETC ...
> >
> > Oracle, will ya get on this right away!!!!
> >
> > ;)
>
> One more keyword to SQL syntax? As if it's not a mess already?
>
> I would suggest more general solution. Allow nesting arbitrary SQL on
> column level. Your example would become something like
>
> SELECT COLUMNS(
> select name from user_columns
> where table_name = 'EMP'
> minus
> select name from user_columns
> where table_name = 'DEPT'
> ) from EMP
>
> This syntax establishes nice framework for pivot/unpivot operator...

This is a suggestion with which I can agree. Well done.

David Fitzjarrell Received on Fri Feb 25 2005 - 20:15:33 CST