Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00936 select statement in colum list. Is it possible?
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