HOW TO SELECT COUNT(*) FROM MULTIPLE TABLES IN ORACLE SQLs

Posted on September 30, 2021September 30, 2021 by kishan1 Minute Read

Try this query to count total rows from multiple tables at once

kish@exdbx<>select count(*) from TABX
union all
select count(*) from SALES_TAB
union all
select count(*) from AFTERDROP
union all
select count(*) from SALES_TAB_COPY_TEMP
union all
select count(*) from SALES_TAB_COPY
union all
select count(*) from SALES_MV
union all
select count(*) from DEMO_DUP
union all
select count(*) from SALES_T
union all
select count(*) from SALES;  2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17

                                COUNT(*)
----------------------------------------
                                 1048576
                                 1398102
                                    4000
                                  349526
                                 1398102
                                 1048576
                                 2000001
                                 1048576
                                 4000002

9 rows selected.

Published by kishan

Desire and obsessive to learn ! Generic technology enthusiast who have dynamic experience in database and other technologies. I have persistence to learn any niche skills faster. Served multiple DBA roles in fortune 500 companies to proactively prevent unexpected failure events. Inclined to take risks,face challenging situations and embrace fear! ***I would like to share my thoughts and ideas to this world !*** View all posts by kishan