Home » SQL & PL/SQL » SQL & PL/SQL » problem in SQL
problem in SQL [message #20661] Wed, 12 June 2002 01:09 Go to next message
Kannan
Messages: 29
Registered: September 2000
Junior Member
Sir,
The statement 'select * from cat;'
gives the table name and table type.
Is there any way in SQL (not in PL/SQL) to display the table_name and the no. of records in that table.
For eg.
select * from cat; should give output as :
TABLE_NAME COUNT(*)
********** ********
BONUS 5
EMP 14
DEPT 10 Etc.

Thanks
Kannan

Report message to a moderator

Re: problem in SQL [message #20663 is a reply to message #20661] Wed, 12 June 2002 01:53 Go to previous message
Venkata Krishnayya Kommu
Messages: 13
Registered: July 2000
Junior Member
If u analyze all the tables, u can get the tables along with count of records. Otherwise u have to maitain a view to count the number of records in each table.
HTH
Krishna

Report message to a moderator

Previous Topic: duplicates
Next Topic: Abt Stored Procedure in Forms 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:14:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.