回到从前变成猫的博客

SELECT TO_CHAR (TE.MODDATE, 'hh24') AS TT, COUNT (*) AS TOTALFROM T_B_EXACTDETECT TE --所需要查询数据的表名WHERE TO_CHAR ( TRUNC (TE.MODDATE), 'yyyy-mm-dd') = ( SELECT TO_CHAR (SYSDATE, 'yyyy-m...

可以使用下面语句进行查询关联了该表的其他表select a.constraint_name, a.table_name, b.constraint_name from user_constraints a, user_constraints bwhere a.constraint_type = 'R' and b.constraint_type = 'P' and a.r_constrai...