What statements can be used to show how many records each of my database tables has?

Select table_name, row_nums from user_tables
You can check it out, but before using this statement, you need to analyze each database table so that the number of records is accurate. However, this is not enough for online production business tables, because the production business tables are changing at any time, it takes a long time for a large table to analyze the data. therefore, if you want to count the number of these records at any time, you need to directly query the table, you can create a PL/SQL block to complete, in the block through the cursor to retrieve all the tables, use Dynamic statements to find out.