Re: Selecting out certain columns

Stephen wrote:
>
> Let's say you have a table with 50 columns and you want to retrieve
> data that lists only 49 of those columns. Is there any easy way to do
> this without typing: select column1, column2,...column49 from table.
> So basically is there a way to select out certain columns in your
> statement while retrieving the rest of the columns?
>
> Thanks

In SQL Plus

SQL> col X nopri
SQL> select * from ...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."