Re: Selecting out certain columns

"Stephen" <grider22_at_hotmail.com> wrote in message news:22d5cb4a.0205021033.445964d9_at_posting.google.com...
> 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?

I'm not clear on the context ... is this if you were writing an sproc? I use xemacs while I develop code and because of that, I can have one 'window' (in emacs lingo) with a SQL*PLUS session. I can do a 'describe' on a table, copy the contents of the output to another window (buffer) and nuke the columns that I don't need.

The same principle can be applied if you use the windows version of SQL*PLUS and issue a 'describe' and COPY the screen to your favorite editor where you can mash, spindle and mutilate with no federal penalties whatsoever.

Did I answer your question? Heh heh! I'm not sure ...

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts