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 -> Re: ORA-00936 select statement in colum list. Is it possible?

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

From: Dimitry <dmitry_av_at_urbis.net.il>
Date: 2000/05/30
Message-ID: <39338916@news.bezeqint.net>#1/1

You are very hard to understand.
Your second SELECT brings you a column of values from the field B.column_b. So why do you place it instead of column name? These things are completely different.
Could you be a bit more specific?

Young Lee <young.lee_at_supplysolution.com> wrote in message news:392BF24C.F83984F1_at_supplysolution.com...
> 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 Tue May 30 2000 - 00:00:00 CDT

Original text of this message

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