qq_39505553的博客

1、使用union把多个参数生成一张参数表 SELECT * FROM( SELECT '1' A FROM DUAL UNION SELECT '2' A FROM DUAL UNION SELECT '3' A FROM DUAL UNION SELECT '4' A FROM DUAL UNION SELECT '5' A FROM DUAL UNION SELECT '6' A FROM...

查询出被删除表名 select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin order by DROPTIME desc; BIN$v7NJ2kOSQK69uG77XshGYw==$0 T_CHRYSLER_PARTS_BAK TAB...