Oracle : which SQL command to get all details about a table?
<p>I am developing an Oracle database schema visualizer. So, as a first step, I thought, I will first need to get all the schema details (tables and relationships between tables, constraints also maybe).</p>

<p>To get that information, what is the SQL command that will return the result?</p>

<p>(the <code>DESCRIBE</code> command does not return the information about the all the table)</p>

<p><strong>EDIT #1</strong>:</p>

<p>Actually, what I want to do is to get all the information about all tables as I mentioned (columns, rows, foreign keys, constraints) to store them ina MongoDB database, and then create visualizations (diagrams are not included)</p>