Oracle怎样查看自己有哪些表

方法1：

SQL> select tname from tab wheretabtype='TABLE';

TNAME

------------------------------------------------------------

REGIONS

LOCATIONS

JOB_HISTORY

JOBS

EMPLOYEES

DEPARTMENTS

COUNTRIES

7 rows selected.

方法2：

SQL> select table_name from user_tables;

TABLE_NAME