title: An equivalence of ".schema sqlite_master" in Oracle
body: <p>I'm trying to do the same exercise for both SQLite and Oracle. In SQLite, there is a table <code>sqlite_master</code> containing a description of all of the other tables, indexes, triggers, and views that are contained within the database. I can see the query to generate <code>sqlite_master</code> with <code>.schema sqlite_master</code>.</p>
  <p>In Oracle, the data dictionary is presented to us in the form of a number of views (<code>DBA</code>, <code>ALL</code> or <code>USER</code>). Let's take the table <code>USER_TABLES</code> as an example. We can do query on <code>USER_TABLES</code>, for example</p>
  <pre><code>SELECT table_name
  FROM USER_TABLES;
  </code></pre>
  <p>Is there anyway to get the query used to create the table <code>USER_TABLES</code> in Oracle? I tried</p>
  <pre><code>SELECT dbms_metadata.get_ddl('TABLE', 'USER_TABLES')
  FROM dual;
  </code></pre>
  <p>but it does not work.</p>