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

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

From: Gerd Kock <Gerd.Kock_at_BITS-on-the.net>
Date: 2000/05/26
Message-ID: <392e99bc.1035993@news.btx.dtag.de>#1/1

why not use this:

select column_a, column_b
from A,B
where A.column_a = B.column_b
and column_a = 'test';

HtH
On Wed, 24 May 2000 08:16:28 -0700, Young Lee <young.lee_at_supplysolution.com> wrote:

>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
>
>
>

Gerd Kock
Baltic IT Service GmbH
Gerd.Kock_at_BITS-on-the.net Received on Fri May 26 2000 - 00:00:00 CDT

Original text of this message

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