你可以通过查询dictionary这个表找出系统提供的所有数据字典表和视图 SQL>select table_name from dictionary;常见的系统表通常以DBA,USER,ALL开头,常见系统视图以V$开头都可以在这个表里查到如 SQL> select count(table_name) from dictionary where table_name like 'DBA_%';COUNT(TABLE_NAME) ----------------- 514SQL> select count(table_name) from dictionary where table_name like 'USER_%';COUNT(TABLE_NAME) ----------------- 283SQL> select count(table_name) from dictionary where table_name like 'ALL_%';COUNT(TABLE_NAME) ----------------- 266SQL> select count(table_name) from dictionary where table_name like 'V$%';COUNT(TABLE_NAME) ----------------- 398
SQL>select table_name from dictionary;常见的系统表通常以DBA,USER,ALL开头,常见系统视图以V$开头都可以在这个表里查到如
SQL> select count(table_name) from dictionary where table_name like 'DBA_%';COUNT(TABLE_NAME)
-----------------
514SQL> select count(table_name) from dictionary where table_name like 'USER_%';COUNT(TABLE_NAME)
-----------------
283SQL> select count(table_name) from dictionary where table_name like 'ALL_%';COUNT(TABLE_NAME)
-----------------
266SQL> select count(table_name) from dictionary where table_name like 'V$%';COUNT(TABLE_NAME)
-----------------
398