ORACLE获取当前数据库的所有表名字段名和注释

-----------所有表---------------
--select * from user_tables;
-----------表名,表注释---------------
select user_tab_comments.TABLE_NAME,user_tab_comments.COMMENTS 
from user_tab_comments 
where Table_Name='xx';

-----------字段,字段注释---------------
select * 
from user_col_comments 
where Table_Name='xx'
order by column_name;

-----------字段,长度,类型---------------
select * from user_tab_columns where Table_Name='xx'; 

select user_col_comments.TABLE_NAME ,
user_col_comments.COLUMN_NAME,
user_col_comments.COMMENTS ,
user_tab_columns.DATA_LENGTH ,
user_tab_columns.DATA_TYPE
,user_tab_columns.COLUMN_ID
from user_col_comments,user_tab_columns
WHERE user_tab_columns.COLUMN_NAME=user_col_comments.COLUMN_NAME
and user_tab_columns.Table_Name=user_col_comments.Table_Name 

and user_tab_columns.Table_Name='xx'

;