Sub-query not working

From: <david_holthus_at_my-deja.com>
Date: Fri, 22 Dec 2000 00:25:58 GMT
Message-ID: <91u72g$441$1@nnrp1.deja.com>

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/ Received on Thu Dec 21 2000 - 18:25:58 CST