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: print table name and the number of rows in it

Re: print table name and the number of rows in it

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Wed, 07 Dec 2005 11:49:15 +0200
Message-ID: <4396b01b$0$13468$ba624cd0@newsread.funet.fi>


Sreelal wrote:
> i want to print all the tables names owned by a user along with their
> number of rows...
>
> give me query
> thankz
>

select table_name, num_rows
from user_tables
order by 1;

gives tables of the current user.

--
Arto Viitanen
Espoo, Finland
Received on Wed Dec 07 2005 - 03:49:15 CST

Original text of this message

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