Calculate total number of rows per schema.
MaahjoorMay 14 2013 — edited May 16 2013Dear all,
i am using oracle database 10g against windows 2003 server.
i want to calculate total number of rows in a schema.
i have only one method to just select count(*) from each table inside each schema.
as there any possible query which could calculate total number of rows in a schema?
Thanks.
Edited by: Maahjoor on May 13, 2013 11:21 PM