How to query how many tables there are in oracle

In Oracle, you can use the select statement with "count (*)" to query how many tables there are. This statement can display the number of all tables in the database. The syntax is "select count (*) from user_tables; ".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to query how many tables there are in oracle

Query the total number of tables under the current user.

After logging in to the sys user, check the number of tables under the current user through the user_tables table.

conn / as sysdba;

select count（*） from user_tables ;

Explanation: After logging in to the system as a super user, read the number of rows recorded in the "user table" through the above sql (each table There will be one record), which is the number of tables under the current database.

Examples are as follows:

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to query how many tables there are in oracle. For more information, please follow other related articles on the PHP Chinese website!