视图showtables查看表的名称和注释

create or replace view showtables as
select
a.table_name as tableName,
a.comments as tableComment,
a.owner as UserId,
a.owner as tableUser,
t.TABLESPACE_NAME as DatabaseName,
t.LAST_ANALYZED as CreateTime,
t.LAST_ANALYZED as UpdateTime
from
all_tab_comments a,
tabs t
where
a.table_type='TABLE'
and t.table_name = a.table_name;