RE: urgent..! how to combining 2 querries...

From: Rooy van, Marco <m.vanrooy_at_sfs.nl>
Date: Tue, 03 Jul 2001 05:25:37 -0700
Message-ID: <F001.0033FC24.20010703045051@fatcity.com>

 

select a.tablespace_name, a.bytes, b.bytes   from (Select tablespace_name, sum(bytes) as bytes

          from dba_data_files 
         group by tablespace_name) a,
       (Select tablespace_name, sum(bytes) as bytes
          from dba_free_space 
         group by tablespace_name) b

 where a.tablespace_name = b.tablespace_name;

Best regards,

Marco  

-----Oorspronkelijk bericht-----
Van: Saurabh Sharma [mailto:ssharma1_at_fcsltd.com] Verzonden: dinsdag 3 juli 2001 13:46
Aan: Multiple recipients of list ORACLE-L Onderwerp: urgent..! how to combining 2 querries...

hi gurus,  

any body have any idea of how to join these querries. i want to select from two different tables namely dba_data_files call it A and dba_free_space call it B. but the columns being selected are same i.e. tablespace_name and bytes from both tables.  

i want to select in a single querry as..  

tablespace_name        bytes1        bytes2


--                                --                --        




--                                --                --        

--                                --                --        

 

where bytes1 is sum(bytes) group by tablespace_name in table a. and bytes2 is sum(bytes) group by tablespace_name in table b.  

Saurabh Sharma  

saurabh.sh_at_usa.net <mailto:saurabh.sh_at_usa.net> http://www.geocities.com/saurabh00pc/stride.html <http://www.geocities.com/saurabh00pc/stride.html>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rooy van, Marco
  INET: m.vanrooy_at_sfs.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_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). Received on Tue Jul 03 2001 - 07:25:37 CDT