有啊,TOAD里面就有Format Code这个功能。整理前:select (select count(*) from a1)-(select count(*) from (select distinct a1.id from a1,a2 where a1.kssj>=a2.kssj2 and a1.jssj<=a2.jssj2)) from dual整理后:
SELECT (SELECT COUNT (*)
FROM a1)
- (SELECT COUNT (*)
FROM (SELECT DISTINCT a1.ID
FROM a1, a2
WHERE a1.kssj >= a2.kssj2 AND a1.jssj <= a2.jssj2))
FROM DUAL
SELECT (SELECT COUNT (*)
FROM a1)
- (SELECT COUNT (*)
FROM (SELECT DISTINCT a1.ID
FROM a1, a2
WHERE a1.kssj >= a2.kssj2 AND a1.jssj <= a2.jssj2))
FROM DUAL
可在那里能下载TOAD呢?
在google里找了好几个都不能下载....T_T
可怜可怜我吧....