I need to get a count(*) from two tables.
Example:
a_user and b_project.

I can't do a select count(*) from a_user, b_project because that is't
accurate.

I want the output to look like:


Tablename count Tablename
98000 a_user
1000000 b_project





Oracle LazyDBA home page