Re: Sub-query not working

What happens if you try:

select
(select count (*) from all_tables) as tablecount, (select count (*) from all_indexes) as indexcount from dual;

In article <91u72g$441$1_at_nnrp1.deja.com>,   david_holthus_at_my-deja.com wrote:
> The following query works on only 1 of our servers (the server with
 the
> highest version of oracle) :
>
> select
> (select count (*) from all_tables) as tablecount,
> (select count (*) from all_indexes) as indexcount
> from all_tables where rownum =1
>
> Server Versions:
> server1 : Oracle8 Release 8.0.5.2.1 - Production
> server2 : Oracle7 Server Release 7.3.2.3.14 - Production Release
> server3 : Oracle8 Release 8.0.5.2.0 - Production
> server4 : Oracle8i Release 8.1.5.0.0 - Production
>
> The error I get on the other 3 servers is:
> ORA-00936: missing expression
>
> Is the solution version-dependent, or is there something else I can do
> to fix the problem
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 19:53:19 CST