Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> SQL query?
Hello,
I'd like to create a query on table which has 20 fields (F1,F2,...F20), but
I need to exclude five fields from the query and I can't use rest of fields
explicitly.
So I try do that like :
SELECT (SELECT COLUMN_NAME||',' FROM USER_TAB_COLUMNS
WHERE TABLE_NAME='MYTABLE' AND COLUMN_NAME NOT IN
('F1','F17','F18','F19','F20'))
FROM MYTABLE;
But it doesn't work.
How could I fix this expression to get proper result?
Thanks,
Gennady
Received on Thu Jun 15 2000 - 00:00:00 CDT
![]() |
![]() |