title: Merge the output of two sys_refcursor
body: <p>I've two functions in oracle 11g which return a sys_refcursos.
  The first in this</p>
  
  <pre><code>create or replace FUNCTION num_gettoni
      (cf_parlamentare IN parlamentari.cf %TYPE DEFAULT 'MRTMRZ'
        --, num_legislatura in legislature.id%TYPE
      ) RETURN SYS_REFCURSOR
    AS
      my_cursor SYS_REFCURSOR;
      pippo legislature.id%type;
    BEGIN
  
      OPEN my_cursor FOR
  
      select
        leg, 
        ct as gettoni
      from( 
         SELECT
           l.id AS leg,
           COUNT(*) - lead(COUNT(*), 1, 0) over (order by l.datainizio) AS ct
         FROM
           legislature l,
           partecipazioni i,
           parlamentari p
         WHERE 
           i.sedute_data &gt;= l.datainizio 
           AND p.cf = i.parlamentare 
           AND p.cf = cf_parlamentare
  
         group by l.datainizio, l.id
      )
  
      where ct &gt; 0
      order by ct desc;
  
      /*open my_cursor;
      loop
      pippo := my_cursor.leg;
      END LOOP;
  
      end loop;*/
  
      RETURN my_cursor;
    END num_gettoni;
  </code></pre>
  
  <p>An example of the output of the first funzion is</p>
  
  <pre><code>select num_gettoni('MRTMRZ') from dual;
  
  NUM_GETTONI('MRTMRZ') 
  --------------------- 
  LEG                    GETTONI                 
  ---------------------- ----------------------  
  17                     3                       
  18                     2
  </code></pre>
  
  <p>The second function is similar and the output of second function is</p>
  
  <pre><code>select num_interrogazioni('MRTMRZ') from dual;
  
  NUM_INTERROGAZIONI('MRTMRZ') 
  -------------------------------------- 
  LEG                    INTERROGAZIONI          
  ---------------------- ----------------------  
  18                     1                     
  </code></pre>
  
  <p>Is possible to call these functions through a procedure and have a result similar at the following?</p>
  
  <pre><code>NUM_INTERROGAZIONI('MRTMRZ') 
      -------------------------------------- 
      LEG                    GETTONI                 INTERROGAZIONI 
      ---------------------- ---------------------- ----------------------  
      17                     3                       
      18                     2                       1
  </code></pre>