title: SQL statement to display table names, its structures, and constraint information
body: <p>Im looking for an Oracle SQL statement that will show me all the table names, structures and constraint information that I have created.</p>
  
  <p>Would it be something along the lines of</p>
  
  <pre><code>Select * from user_tables;
  </code></pre>