【统计数据条数大于2的】
SELECT SERIAL_NUMBER FROM V_SIMPLE_ENTRUSTMANAGEMENT GROUP BY SERIAL_NUMBER HAVING COUNT(SERIAL_NUMBER)>2
【表注释查询】
SELECT * FROM user_tab_comments WHERE TABLE_NAME='TQMTOTRT1'
【表列名注释查询】
SELECT * FROM user_col_comments WHERE TABLE_NAME='TQMTOTRT1'
标签:常用,NUMBER,comments,SQL,Oracle,TABLE,SERIAL,TQMTOTRT1,SELECT From: https://www.cnblogs.com/qhri/p/16731206.html