Re: SELECT in a [select_list]

It's possible but only by using embedded SQL.

abeba_at_my-deja.com wrote:
>
> Using Oracle8, I want to submit this query :
>
> SELECT a , (SELECT MAX(b) FROM c)
> FROM d
>
> but I keep having the same message : (ORA-00936 missing expression)
>
> Is it possible to have a query in a [SELECT_LIST]
> or are there any other ways to do the same thing ????
Received on Mon Jul 26 1999 - 06:32:35 CDT