SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select * except 1 column

Alistair LaingJul 28 2008 — edited Jul 28 2008

Hi

I have a select * that retrieves 30 columns of data now what I want to do is select all except 1 or possibly two. Is there any syntax that I could use to achieve this without having to input all the column names that I need.

Many Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2008

Added on Jul 28 2008

6 comments

4,016 views