Query all user tables in Oracle

To query all the user tables in Oracle, USER_TABLES sometimes needs to clean up, count, and analyze existing databases. This requires you to know how much data there are in the databases. in Oracle, you can use the view USER_TABLES: SELECT * FROM USER_TABLES; USER_TABLES provides a wealth of information, of which the more important is the number of data rows in the table (column NUM_ROWS ), however, the number of rows in this column is not accurate. It may be consistent with the COUNT result of a specific table. This is because num_rows obtains the number of rows based on the analysis table, you must first Analyze the Table to obtain the correct number of data rows. Www.2cto.com to query columns in all user tables, you can use USER_TAB_COLUMNS to query the tables in which a column appears. SELECT * FROM USER_TAB_COLUMNS; in addition, you can use user_tables to query the table of the current user; all_tables to query the tables of all users; dba_tables to query all the table authors of the system table cat