Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gABCYMG31133 for ; Mon, 11 Nov 2002 06:34:22 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gABCYMX31128 for ; Mon, 11 Nov 2002 06:34:22 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id CAA21979; Mon, 11 Nov 2002 02:14:55 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004FFEC8; Mon, 11 Nov 2002 02:03:39 -0800 Message-ID: Date: Mon, 11 Nov 2002 02:03:39 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Nirmal Kumar Muthu Kumaran Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Nirmal Kumar Muthu Kumaran Subject: RE: ORACLE QUERY Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C28969.1AD9ADC0" ------_=_NextPart_001_01C28969.1AD9ADC0 Content-Type: text/plain 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----- Sent: Monday, November 11, 2002 11:13 AM To: Multiple recipients of list ORACLE-L 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) ---------------------------------------------------- ------_=_NextPart_001_01C28969.1AD9ADC0 Content-Type: text/html

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:savita@india.hp.com]
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)
----------------------------------------------------

------_=_NextPart_001_01C28969.1AD9ADC0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: NIRMALK@qtel.com.qa Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).