title: ORACLE SQL DEVELOPER-select count(*) from multiple databases
body: <p>How can I select count(*) from two different databases(call them ZEOTA and SP) having as result:</p>
  <pre><code>Zeota SP
    88  3
  </code></pre>
  <p>I have tried this:</p>
  <pre><code>SELECT COUNT(CONSTRAINT_TYPE) NumberOfPrimaryKeys_Zeota 
  FROM ALL_CONSTRAINTS
  WHERE CONSTRAINT_TYPE = 'P' 
  AND 
  OWNER = 'ZEOTA';
  SELECT COUNT(*) AS NumberOfAttributes_SP
  FROM ALL_COL_COMMENTS
  WHERE OWNER = 'SP';
  </code></pre>
  <p>But the output shows two separate query results:</p>
  <pre><code>Query result 1: 
      Zeota
        88
  Query Result 2:
        SP
        3
  </code></pre>
  <p>However I am trying to do it this way, but having issues:</p>
  <pre><code>SELECT 
  COUNT(DISTINCT TABLE_NAME) AS ZNumOfTables,
  COUNT(DISTINCT TABLE_NAME) AS SNumOfTables,
  COUNT(DISTINCT TABLE_NAME) AS PNumOfTables
  FROM ALL_TAB_COLUMNS
  WHERE OWNER = 'SP';
  WHERE OWNER = 'ZEOTA';
  </code></pre>