Re: Would be really nice if...

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... Received on Fri Feb 25 2005 - 19:47:37 CST