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_count
FROM 
    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
    ) t3

WHERE 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_count
FROM
	t_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_count
FROM
	t_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_COUNT
FROM 
    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
    ) T3

WHERE T1.ID = T2.ID1(+)
    AND T2.ID1 = T3.ID2(+)
ORDER BY T1.OPERATION_TIME DESC

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

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

java js 格式

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

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