文件名称:检索表信息-oracle基础讲义
文件大小:4.17MB
文件格式:PPT
更新时间:2024-05-12 07:16:05
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