You could do it by generating your SQL and only then submit it to oracle.
In one pass, as you've tried, I think it's not possible.
<mguillem_at_my-deja.com> wrote in message news:81tjue$86b$1_at_nnrp1.deja.com...
> Is it possible to select the columns to select?
>
> I want to select the values from all columns of a table excepted the
> first colum. The number of columns may increase so I'd like to select
> the columns to select from sys.all_tab_columns
>
> That would be something like this:
> select (select column_name from sys.all_tab_columns where table_name =
> 'MY_TABLE' and owner = 'MYSELF' and column_name <> 'MYNOTWANTEDCOL')
> from MY_TABLE
>
> I get
> ORA-00936 missing expression
>
> Any idea?
>
> Marc.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 29 1999 - 05:03:31 CST
