-- 查询表的所有字段
select *
from user_tab_comments
where TABLE_NAME = 'xx';
select *
from user_col_comments
where TABLE_NAME = 'xx';
select *
from ALL_TAB_COLUMNS
where TABLE_NAME = 'xx';
select t1.TABLE_NAME,t1.COLUMN_NAME,t1.COMMENTS,t2.DATA_TYPE,t2.DATA_LENGTH
from user_col_comments t1
left join ALL_TAB_COLUMNS t2
on t1.TABLE_NAME = t2.TABLE_NAME and t1.COLUMN_NAME=t2.COLUMN_NAME
where t1.TABLE_NAME='xx'
order by t2.column_id;
标签：NAME,t2,表字,t1,xx,Oracle,TABLE,查询,select From： https://www.cnblogs.com/YinXuanZhiZhi9/p/16829208.html