获取oracle 里的表名与字段

 

--数据库表名

SELECT distinct A.OBJECT_NAME as TAB_NAME,B.comments as DESCR FROM USER_OBJECTS A
, USER_TAB_COMMENTS B where A.OBJECT_NAME=B.TABLE_NAME

 

 

--数据库字段

 select  t.column_name as f_code,t.comments as f_name from user_col_comments t where t.table_name = '表名'