How can I select cols to select

From: <mguillem_at_my-deja.com>
Date: Mon, 29 Nov 1999 10:18:55 GMT
Message-ID: <81tjue$86b$1@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 - 04:18:55 CST