Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL query?

SQL query?

From: Gennady <gennadyb_at_halcosoftware.com>
Date: 2000/06/15
Message-ID: <39490221$0$15323@fountain.mindlink.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US