Oracle基础讲义中的检索表信息部分

检索表信息 有关表的信息可从查询下面的视图中获取： 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