RE: ORACLE QUERY

[Nirmal Kumar Muthu Kumaran]

select record_identifier from records where rownum<(

select 40-count(*) from

(select 1 from customer_view

union all

select 2 from unit_view)

);

 

Just a thought, HTH.

 

Nirmal.

-----Original Message-----
From: Savita [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 11, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
Subject: ORACLE QUERY

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)
----------------------------------------------------