There is no easy way to do this. you could consider using a view.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"peter aris" <arispet_at_hotmail.com> wrote in message
news:e4147bfb.0112040410.401ccaa4_at_posting.google.com...
> Hello,
>
> Is there an easy way to choose all columns except some particular of them?
>
> I want to define only the columns I don't want to choose.
>
> Something like :
>
> SELECT {*-{col1,col2,...,coln}}
> from table_name;
>
> I want this facility for not dublicating some columns in inner joins of
> tables with identical columns.
>
>
> thanks in advance
Received on Tue Dec 04 2001 - 08:01:36 CST
