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

Home -> Community -> Usenet -> c.d.o.server -> ORA-00936 select statement in colum list. Is it possible?

ORA-00936 select statement in colum list. Is it possible?

From: Young Lee <young.lee_at_supplysolution.com>
Date: 2000/05/24
Message-ID: <392BF24C.F83984F1@supplysolution.com>#1/1

I am trying to use a select statement in column list and got ORA-00936 error.
Is there any way around it?

For example,
select column_a, (select column_b from B where A.column_a=B.column_b) from A where column_a = 'test';

Thanks,
Young Lee Received on Wed May 24 2000 - 00:00:00 CDT

Original text of this message

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