title: How to choose tables on select from all_tables?
body: <p>I have the following table name template, there are a couple with the same name and a number at the end: fmj.backup_semaforo_geo_THENUMBER, for example:</p>
  
  <pre><code>select * from fmj.backup_semaforo_geo_06391442
  select * from fmj.backup_semaforo_geo_06398164
  ...
  </code></pre>
  
  <p>Lets say I need to select a column from every table which succeeds with the 'fmj.backup_semaforo_geo_%' filter, I tried this:</p>
  
  <pre><code>    SELECT calle --This column is from the backup_semaforo_geo_# tables
       FROM (SELECT table_name
        FROM all_tables
       WHERE owner = 'FMJ' AND table_name LIKE 'BACKUP_SEMAFORO_GEO_%');
  </code></pre>
  
  <p>But I'm getting the all_tables tables name data:</p>
  
  <pre><code>TABLE_NAME
  ----------
  BACKUP_SEMAFORO_GEO_06391442
  BACKUP_SEMAFORO_GEO_06398164
  ...
  </code></pre>
  
  <p>How can I achieve that without getting the all_tables output?</p>
  
  <p>Thanks.</p>