Oracle List of all Tables, values in table
<p>I am trying to develop report in tableau with back end as oracle.</p>

<p>I have a database where I have 30 owners and 20 tables in each owner , so is there a way in oracle I can display all data in tables per owner.</p>

<p>My Query :</p>

<pre><code>Select distinct Owner as t1,Table_Name as t2  From All_Tables Where Owner='I7I  And Table_Name Like '%UPDATE'
</code></pre>

<p>I am only getting Owner name and table name, unable to get data related to that particular table.<br>Some one please guide me.</p>

<p>Thanks<br>
Addy</p>