oracle tables database

Posted by Malar under Others on 7/13/2012 | Points: 10 | Views : 1104 | Status : [Member] | Replies : 2
how to get total number of tables in database in oracle




Responses

Posted by: Sekar.C on: 7/13/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
SELECT Count(*) FROM DBA_TABLES;
Or
select owner, count(*) from dba_tables;



Regards
Sekar.c

Malar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dotnetrajanikanth on: 7/13/2012 [Member] Starter | Points: 25

Up
0
Down
Select count(*) from tab;

____________
www.flickr.com/photos/psdesigner/

Malar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response