Count(*) each table from user_tables

  • From: "Mihalis I. Tsoukalos" <mtsouk@xxxxxxxxxxx>
  • To: Oracle Mailing List <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Fri, 2 Jul 2004 09:32:36 +0300

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
-----------------------------------------------------------------

Other related posts: