oracle sql format

--0.14sec--SELECT    id, name, start_time, end_time, year, status, del_flag, founder_id,    founder_time, operator_id, operation_time,procedure_name,    TRUNC(t3.complete_count / t2.form_count, 2) AS progress, t2.form_countFROM     t_fb_fill_in_batch t1,        (    SELECT         t1.id AS id1 , count(1) AS form_count     FROM         t_fb_fill_in_batch t1, t_fb_batch_form t2, t_fb_form t3    WHERE t1.id = t2.batch_id AND t2.form_id = t3.id AND t3.tablename IS NOT NULL     GROUP BY t1.id    ) t2,        (    SELECT         t.id AS id2,        (SELECT count(1)FROM t_fb_flow WHERE biz_id IN (SELECT form_id FROM t_fb_batch_form WHERE batch_id = t.id) AND handle_st = '9') AS complete_count    FROM         t_fb_fill_in_batch t    ) t3WHERE t1.id = t2.id1(+)    AND t2.id1 = t3.id2(+)   --     <if test="vo.name !=null and vo.name !='' ">   --         and t1.name like CONCAT(CONCAT('%',#{vo.name}),'%')   --     </if>ORDER BY t1.OPERATION_TIME DESC----------------------------------------------------------------------------------------------------------------------------------------------------------SELECT t.id AS id2,(SELECT count(1) FROM t_fb_flow t6 WHERE t6.biz_id IN (SELECT t5.form_id FROM t_fb_batch_form t5 WHERE t5.batch_id = t.id) AND t6.handle_st = '9') AS complete_countFROMt_fb_fill_in_batch t--IN < EXISTS--SELECT t.id AS id2,(SELECT count(1) FROM t_fb_flow t6 WHERE EXISTS (SELECT 'x' FROM t_fb_batch_form t5 WHERE t5.batch_id = t.id AND t6.biz_id = t5.form_id) AND t6.handle_st = '9') AS complete_countFROMt_fb_fill_in_batch t------------------------------------------------------------------------------------------------------------------------------------------------------------0.078 - 0.094 sec--SELECT    ID, NAME, START_TIME, END_TIME, YEAR,    STATUS, DEL_FLAG, FOUNDER_ID, FOUNDER_TIME,     OPERATOR_ID, OPERATION_TIME, PROCEDURE_NAME,    TRUNC(T3.COMPLETE_COUNT / T2.FORM_COUNT, 2) AS PROGRESS,     T2.FORM_COUNTFROM     T_FB_FILL_IN_BATCH T1,        (    SELECT         T1.ID AS ID1,        COUNT(1) AS FORM_COUNT     FROM         T_FB_FILL_IN_BATCH T1, T_FB_BATCH_FORM T2, T_FB_FORM T3    WHERE T1.ID = T2.BATCH_ID AND T2.FORM_ID = T3.ID AND T3.TABLENAME IS NOT NULL     GROUP BY T1.ID    ) T2,        (    SELECT         T.ID AS ID2,        (SELECT COUNT(1)FROM T_FB_FLOW WHERE BIZ_ID IN (SELECT FORM_ID FROM T_FB_BATCH_FORM WHERE BATCH_ID = T.ID) AND HANDLE_ST = '9') AS COMPLETE_COUNT    FROM         T_FB_FILL_IN_BATCH T    ) T3WHERE T1.ID = T2.ID1(+)    AND T2.ID1 = T3.ID2(+)ORDER BY T1.OPERATION_TIME DESC

无论JAVA、JavaScript、SQL，层次感很差，阅读性很差，维护起来那个看得就是头疼。

截取部分代码段。如果上几千行代码要看懂人家说需要一周，我觉得一点都不过分，太累，时间成本不亚于重新写。

java js 格式

有什么不能交流的，相互伤害，相互进步嘛。。。。。。

那么血案是怎么发生的呢？吃饱饭：