Re: Selecting out certain columns

Thanks Connor.

What's up with that Sybrand guy?

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3CD18957.7D5_at_yahoo.com>...
> 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
Received on Fri May 03 2002 - 15:12:22 CDT