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 |