Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus: Expressions using inner selects not supported?
This is sybase syntax.....
Jonathan Gennick wrote:
>
> On 23 Feb 1998 14:28:38 GMT, Steve Frampton
> <3srf_at_qlink.queensu.FOOBAR.ca> wrote:
>
> > select 5 +
> > (select 10 from dual)
> > from dual;
> >
> >does not appear to work.
>
> That's because it's not syntactically correct. A subquery
> cannot appear in the item list of a select statement. I'm
> sure I could think of many rationalizations for it, but the
> bottom line is that it's not standard SQL.
>
> Jonathan
Received on Fri Feb 27 1998 - 00:00:00 CST