Dear list, I have the following question: I want to count(*) every table from users_table table using SQL. I know how to do it in PL/SQL but not in SQL. Can you please help me do it? many thanks in advance, Mihalis. -- 09:31:15 up 12 days, 22:35, 2 users, load average: 0.04, 0.03, 0.06 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------