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
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
转载于:https://www.cnblogs.com/huashengweilong/p/10960944.html