title: SELECT statement to get all columns from different tables
body: <p>I have multiple tables that begin with "PLAYERS_" and they consist of some data that I am trying to retrieve at once. I may add more tables in the future that begin with "PLAYER_" so I want to have a select statement that will get me all data of these tables without me selecting from all of these tables. </p>
  
  <p>Here is a select statement that I am trying to use but I don't think its accurate: </p>
  
  <pre><code>SELECT * FROM (SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'PLAYER_%';
  </code></pre>
  
  <p>All is this doing is getting me results of the subquery which is tables' info (not what I need). Is there an alternative way to achieve what I am trying to achieve? </p>
  
  <p>What I'm trying to achieve is the same as: </p>
  
  <pre><code>SELECT * FROM PLAYER_1, PLAYER_2, PLAYER_3; 
  </code></pre>
  
  <p>But I want to do it in a way that I shouldn't worry about putting table names like that. </p>