Selecting all tables with no records <p>I need to display all tables that have zero records.</p> <p>I tried,</p> <pre><code>select * from user_all_tables where (select count(*) from user_all_tables)=0; </code></pre> <p>But it doesn't seem to work. How should I go about redesigning this query? Thanks.</p>