select
t.TABLE_NAME,
m.comments
from user_tables t, user_tab_comments m
where t.TABLE_NAME = m.table_name and m.comments is not null
order by T.TABLE_NAME asc;
Oracle:查询用户数据表及表注释名称
最新推荐文章于 2024-03-27 02:07:09 发布
select
t.TABLE_NAME,
m.comments
from user_tables t, user_tab_comments m
where t.TABLE_NAME = m.table_name and m.comments is not null
order by T.TABLE_NAME asc;