title: Get list of table names in different schema of an Oracle database
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/205736/oracle-get-list-of-all-tables">Oracle: get list of all tables?</a><br>
    <a href="https://stackoverflow.com/questions/2247310/how-do-i-list-all-tables-in-a-schema-in-oracle-sql">How do I list all tables in a schema in Oracle SQL?</a>  </p>
  </blockquote>
  
  
  
  <p>I want to list all table in another schema.</p>
  
  <pre><code>connect hr/hr; 
  select table_name from user_tables;
  </code></pre>
  
  <p>but I want to skip the "connect" command. I want to run query from another schema.
  Is that possible to do? </p>