Oracle查询数据库元数据

-- 获取表字段-- user_tab_columns 字段-- table_name 表名称-- column_name 字段名-- data_type 字段类型-- data_length 字段长度-- ...select * from user_tab_columns where table_name='table_name';-- 获取表注释-- table_name-- table_type-- comments 注释select * from user_tab_commentswhere table_name='table_name';-- 获取字段注释-- table_name-- column_name-- commentsselect * from user_col_commentswhere table_name='table_name';-- 获取表名称select table_name from user_tables;select table_name from all_tables;select table_name from dba_tables;select table_name from dba_tables where owner='?' ; -- 获取属于谁的表