Selecting all tables with no records

Posted by sqlgrasshopper5 on Stack Overflow See other posts from Stack Overflow or by sqlgrasshopper5
Published on 2010-05-17T10:56:54Z Indexed on 2010/05/17 11:01 UTC
Read the original article Hit count: 118

Filed under:
|

I need to display all tables that have zero records.

I tried,

select * from user_all_tables where (select count(*) from user_all_tables)=0;

But it doesn't seem to work. How should I go about redesigning this query? Thanks.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about sql