【文件属性】:
文件名称:检索表信息-oracle基础讲义
文件大小:4.17MB
文件格式:PPT
更新时间:2021-04-22 13:29:25
orcle基础讲义
检索表信息
有关表的信息可从查询下面的视图中获取:
DBA_TABLES
DBA_OBJECTS
TAB
TABS
举例:
SQL> SELECT table_name
2 FROM dba_tables WHERE owner = 'HR';
TABLE_NAME
-------------------
COUNTRIES
DEPARTMENTS
DEPARTMENTS_HIST
EMPLOYEES
EMPLOYEES_HIST
JOBS
JOB_HISTORY
LOCATIONS
REGIONS