Oracle常用SQL

【统计数据条数大于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'