Question on SQL*PLU
From: explorer <syed_at_emunix.emich.edu>
Date: 8 Oct 1993 23:39:46 -0500
Message-ID: <9310090441.AA09186_at_emunix.emich.edu>
Date: 8 Oct 1993 23:39:46 -0500
Message-ID: <9310090441.AA09186_at_emunix.emich.edu>
I have a simple question: How can I find the number of records in all tables a user has created? I am trying to do this as a user not as a dba and I am using SQLPLUS . What I am doing right now is spool the result of
SELECT "SELECT COUNT(*) FROM "||TNAME FROM TAB and then run the resulting file.
Is there a better way? Received on Sat Oct 09 1993 - 05:39:46 CET