SELECT A.TABLE_NAME, B.COMMENTS FROM USER_TABLES A, USER_TAB_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME ORDER BY TABLE_NAME
参考博客:
获取oracle数据库当前用户下所有表名和表名的注释 - 尹飞飞 - ITeye博客
https://yinfeifei.iteye.com/blog/751858
2022-12-19 23:07:17
SELECT A.TABLE_NAME, B.COMMENTS FROM USER_TABLES A, USER_TAB_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME ORDER BY TABLE_NAME
参考博客:
获取oracle数据库当前用户下所有表名和表名的注释 - 尹飞飞 - ITeye博客
https://yinfeifei.iteye.com/blog/751858