Count(*) each table from user_tables

From: Mihalis I. Tsoukalos <mtsouk_at_freemail.gr>
Date: Fri, 2 Jul 2004 09:32:36 +0300
Message-ID: <20040702063236.GA9416@asda.gr>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Jul 02 2004 - 01:29:25 CDT