xerces-j-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Savita <sav...@india.hp.com>
Subject ORACLE QUERY
Date Mon, 11 Nov 2002 07:29:50 GMT
Hi All,

I want to know about one query.

I have two views and I want to get the sum of count of two view ex
I have a query like

select record_identifier from records where rownum<(40-(select count(*) from
customer_view+select count(*) from unit_view));

But this is not working in oracle.

Is there any other way to do this without writing a function
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------


Mime
View raw message