Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Return table name and record count

Re: Return table name and record count

From: Jan Kucharski <janek01_at_yahoo.com>
Date: Tue, 14 Jun 2005 21:54:57 +0100
Message-ID: <MPG.1d19547a62b9ab0989680@news.eclipse.co.uk>


In article <1116434496.528510.233330_at_g47g2000cwa.googlegroups.com>, rs_arwar_at_hotmail.com says...
>
> Bruce G. wrote:
> > Hello Group,
> > I was trying to write a script that returns the name of my tables and

providing schema/tables analyzed

select table_name, num_rows
from user_tables;

Jan Received on Tue Jun 14 2005 - 15:54:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US