dbTalk Databases Forums  

How to print the table name and the number of rows it contains in sql query ....

comp.database.oracle comp.database.oracle


Discuss How to print the table name and the number of rows it contains in sql query .... in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prashanth Badabagni
 
Posts: n/a

Default How to print the table name and the number of rows it contains in sql query .... - 09-16-2004 , 07:16 AM






Hi ,
Can any one tell me how to print the table name and number of rows
the table contains (by making use of the tab system table) ... For
example Let us assume that the ' TAB ' table contains the information
of the names of the tables and other information current user schema
... as it is in sqlplus ... Can any one write an sql query that prints
the table name and the number of rows the table contains by making use
of this talbe ' TAB '.

Thanks in advance
Prashanth B

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.