一个排版整齐的SQL能够让大家一目了然其逻辑结构，然而一个排版混乱的SQL光手动排版就会花费几分钟，而且可能还把层次关系排错了。

如下为一个从程序中获取的SQL，排版混乱，读懂其逻辑感觉要掉一层皮，但是有了我们DBCS屠龙刀，问题就迎刃而解了。

如下视频演示了如何使用DBCS进行排版。

select distinct objectivestatusdescription, vcd.order_no, staffname1, createddate, modifieddate, customername, customerno, ???, ????, ????????, ????????, ?????, ??????, ???????, ??????, ?????, ?????, ?????, ????, ??, ???, ???, ??, ???, ????, gd.c, ???? from (select distinct sy.objectivestatusdescription as objectivestatusdescription, tj.order_no as order_no, s.staffname as staffname1, w.createddate as createddate, w.modifieddate as modifieddate, c.customername as customername, c.customerno as customerno, mi.chitno as ???, decode(wm_concat(distinct mi.cust_cont) , 'cont', wm_concat(distinct x.name)) as ????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct xx.comcode)) as ????????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct xx.name)) as ????????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct xxx.name)) as ?????, wm_concat(distinct '????' || np1.key_value || np.key_value || ', ' || mi.info) as ?????? , wm_concat(distinct to_char(w5.modifieddate, 'yyyy-MM-dd hh24:mi:ss') || w5.comments) as ???????, wm_concat(distinct to_char(w6.modifieddate, 'yyyy-MM-dd hh24:mi:ss') || w6.comments) as ?????? , r.rolegroupdescription as ?????, ss.staffname as ?????, (case when ne.his_namereason is not null then '?' else '?' end) as ?????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct i.salechnl)) as ????, decode(wm_concat(distinct mi.cust_cont), 'cont', '???') as ??, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct ii.address) , wm_concat(distinct i.address)) as ???, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct i.riskcode), 'cont', wm_concat(distinct ii.contno)) as ???, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct i.telephone), 'cont', wm_concat(distinct ii.telephone)) as ??, mi.preservation as ???, wm_concat(distinct v.deal_date || v.trace_result) as ????, np.key_value as ???? from tabcnyworkorder tj left join objective w on w.objective_guid = tj.relation_id left join customer c on c.customer_guid = w.customer_guid left join messagechange_info mi on mi.workorderno = tj.order_no left join NY_RELATION_LIST mo on mo.guid = mi.list_guid and mo.s1 = '1' left join sysc_objectivestatus sy on trim(sy.objectivestatus) = trim(w.objectivestatus) left join staff s on s.staff_id = w.createdby left join staff ss on ss.staff_id = w.handleby_id left join rolegroup r on r.rolegroup_id = w.handlegroup_id left join ny_errorreason ne on ne.relation_id = tj.relation_id left join i_continfo_elite i on i.customerno = c.customerno and i.answertype = '0' left join i_continfo_elite ii on ii.contno = mo.contno and ii.answertype = '0' left join ldcom x on substr(i.managecom, 1, 4) = x.comcode left join ldcom xx on substr(i.managecom, 1, 6) = xx.comcode left join ldcom xxx on substr(i.managecom, 1, 8) = xxx.comcode left join NY_PARAMETERS np on np.key_id = mi.projectname and np.Parent_ Id = 'zn_property' and np.Para_Type = 'CHANGE' and np.is_tocompany = '1' left join NY_PARAMETERS np1 on np1.Para_Type = 'CHANGE_TYPE' and np1.key_id = mi.operate left join workorderstep3 w5 on w5.workorder_guid = w.objective_guid and (w5.from_stepidmap = 'B6O6K6' and w5.workorderstepstatus != 'CLOSE') left join workorderstep3 w6 on w6.workorder_guid = w.objective_guid and (w6.from_stepidmap = '3XJI2K' and w6.workorderstepstatus != 'CLOSE') left join (select f.order_no, f.deal_date, f.trace_result from fail_leadingin f where f.status = '1' and f.new_flag = '1') v on v.order_no = tj.order_no where 1 = 1 and w.createddate>=to_date('2018-01-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss') and w.createddate<=to_date('2021-01-01 00:00:0 1', 'yyyy-mm-dd hh24:mi:ss') /* and w.objectivestatus in (!(gdzt)) */ and w.map_id='4SXFJI' /*and i.contno is not null*/ /*and ((substr(x.comcode, 1, length('8636')) in ('8636') and mi.cust_cont='cont') or x.comcode is null)*/ and ((substr(x.comcode, 1, length(8636)) in ('8636') and mi.cust_cont='cont') or x.comcode is null) and ( w.handlegroup_id in (select j.rolegroup_id from jg_distributor j where substr(j.manacom, 1, length(8636)) in ('8636')) or w.handlegroup_id not like 'F%' ) group by sy.objectivestatusdescription, tj.order_no, s.staffname, w.createddate, w.modifieddate, c.customername, c.customerno, mi.chitno, mi.preservation, r.rolegroupdescription, ss.staffname, np.key_value, (ca se when ne.his_namereason is not null then '?' else '?' end)) vcd left join (select count(1) as c, dy.order_no from fail_leadingin dy where dy.status = '1' group by dy.order_no) gd on vcd.order_no = gd.order_noselect distinct objectivestatusdescription, vcd.order_no, staffname1, createddate, modifieddate, customername, customerno, ???, ????, ????????, ????????, ?????, ??????, ???????, ??????, ?????, ?????, ?????, ????, ??, ???, ???, ??, ???, ????, gd.c, ???? from (select distinct sy.objectivestatusdescription as objectivestatusdescription, tj.order_no as order_no, s.staffname as staffname1, w.createddate as createddate, w.modifieddate as modifieddate, c.customername as customername, c.customerno as customerno, mi.chitno as ???, decode(wm_concat(distinct mi.cust_cont) , 'cont', wm_concat(distinct x.name)) as ????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct xx.comcode)) as ????????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct xx.name)) as ????????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct xxx.name)) as ?????, wm_concat(distinct '????' || np1.key_value || np.key_value || ', ' || mi.info) as ?????? , wm_concat(distinct to_char(w5.modifieddate, 'yyyy-MM-dd hh24:mi:ss') || w5.comments) as ???????, wm_concat(distinct to_char(w6.modifieddate, 'yyyy-MM-dd hh24:mi:ss') || w6.comments) as ?????? , r.rolegroupdescription as ?????, ss.staffname as ?????, (case when ne.his_namereason is not null then '?' else '?' end) as ?????, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct i.salechnl)) as ????, decode(wm_concat(distinct mi.cust_cont), 'cont', '???') as ??, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct ii.address) , wm_concat(distinct i.address)) as ???, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct i.riskcode), 'cont', wm_concat(distinct ii.contno)) as ???, decode(wm_concat(distinct mi.cust_cont), 'cont', wm_concat(distinct i.telephone), 'cont', wm_concat(distinct ii.telephone)) as ??, mi.preservation as ???, wm_concat(distinct v.deal_date || v.trace_result) as ????, np.key_value as ???? from tabcnyworkorder tj left join objective w on w.objective_guid = tj.relation_id left join customer c on c.customer_guid = w.customer_guid left join messagechange_info mi on mi.workorderno = tj.order_no left join NY_RELATION_LIST mo on mo.guid = mi.list_guid and mo.s1 = '1' left join sysc_objectivestatus sy on trim(sy.objectivestatus) = trim(w.objectivestatus) left join staff s on s.staff_id = w.createdby left join staff ss on ss.staff_id = w.handleby_id left join rolegroup r on r.rolegroup_id = w.handlegroup_id left join ny_errorreason ne on ne.relation_id = tj.relation_id left join i_continfo_elite i on i.customerno = c.customerno and i.answertype = '0' left join i_continfo_elite ii on ii.contno = mo.contno and ii.answertype = '0' left join ldcom x on substr(i.managecom, 1, 4) = x.comcode left join ldcom xx on substr(i.managecom, 1, 6) = xx.comcode left join ldcom xxx on substr(i.managecom, 1, 8) = xxx.comcode left join NY_PARAMETERS np on np.key_id = mi.projectname and np.Parent_ Id = 'zn_property' and np.Para_Type = 'CHANGE' and np.is_tocompany = '1' left join NY_PARAMETERS np1 on np1.Para_Type = 'CHANGE_TYPE' and np1.key_id = mi.operate left join workorderstep3 w5 on w5.workorder_guid = w.objective_guid and (w5.from_stepidmap = 'B6O6K6' and w5.workorderstepstatus != 'CLOSE') left join workorderstep3 w6 on w6.workorder_guid = w.objective_guid and (w6.from_stepidmap = '3XJI2K' and w6.workorderstepstatus != 'CLOSE') left join (select f.order_no, f.deal_date, f.trace_result from fail_leadingin f where f.status = '1' and f.new_flag = '1') v on v.order_no = tj.order_no where 1 = 1 and w.createddate>=to_date('2018-01-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss') and w.createddate<=to_date('2021-01-01 00:00:0 1', 'yyyy-mm-dd hh24:mi:ss') /* and w.objectivestatus in (!(gdzt)) */ and w.map_id='4SXFJI' /*and i.contno is not null*/ /*and ((substr(x.comcode, 1, length('8636')) in ('8636') and mi.cust_cont='cont') or x.comcode is null)*/ and ((substr(x.comcode, 1, length(8636)) in ('8636') and mi.cust_cont='cont') or x.comcode is null) and ( w.handlegroup_id in (select j.rolegroup_id from jg_distributor j where substr(j.manacom, 1, length(8636)) in ('8636')) or w.handlegroup_id not like 'F%' ) group by sy.objectivestatusdescription, tj.order_no, s.staffname, w.createddate, w.modifieddate, c.customername, c.customerno, mi.chitno, mi.preservation, r.rolegroupdescription, ss.staffname, np.key_value, (ca se when ne.his_namereason is not null then '?' else '?' end)) vcd left join (select count(1) as c, dy.order_no from fail_leadingin dy where dy.status = '1' group by dy.order_no) gd on vcd.order_no = gd.order_no


SELECT DISTINCT
  objectivestatusdescription,
  vcd.order_no,
  staffname1,
  createddate,
  modifieddate,
  customername,
  customerno, ???, ????, ????????, ????????, ?????, ??????, ???????, ??????, ?????, ?????, ?????, ????, ??, ???, ???, ??, ???, ????,
  gd.C, ???? 
FROM
  (
  SELECT DISTINCT
    sy.objectivestatusdescription AS objectivestatusdescription,
    tj.order_no AS order_no,
    s.staffname AS staffname1,
    w.createddate AS createddate,
    w.modifieddate AS modifieddate,
    C.customername AS customername,
    C.customerno AS customerno,
    mi.chitno AS ???,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT x.NAME ) ) AS ????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT xx.comcode ) ) AS ????????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT xx.NAME ) ) AS ????????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT xxx.NAME ) ) AS ?????,
    wm_concat ( DISTINCT '????' || np1.key_value || np.key_value || ', ' || mi.info ) AS ?????? ,
    wm_concat ( DISTINCT to_char( w5.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) || w5.comments ) AS ???????,
    wm_concat ( DISTINCT to_char( w6.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) || w6.comments ) AS ?????? ,
    r.rolegroupdescription AS ?????,
    ss.staffname AS ?????,
    ( CASE WHEN ne.his_namereason IS NOT NULL THEN '?' ELSE'?' END ) AS ?????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT i.salechnl ) ) AS ????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', '???' ) AS ??,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT ii.address ), wm_concat ( DISTINCT i.address ) ) AS ???,
    decode(
      wm_concat ( DISTINCT mi.cust_cont ),
      'cont',
      wm_concat ( DISTINCT i.riskcode ),
      'cont',
      wm_concat ( DISTINCT ii.contno ) 
    ) AS ???,
    decode(
      wm_concat ( DISTINCT mi.cust_cont ),
      'cont',
      wm_concat ( DISTINCT i.telephone ),
      'cont',
      wm_concat ( DISTINCT ii.telephone ) 
    ) AS ??,
    mi.preservation AS ???,
    wm_concat ( DISTINCT v.deal_date || v.trace_result ) AS ????,
    np.key_value AS ???? 
  FROM
    tabcnyworkorder tj
    LEFT JOIN objective w ON w.objective_guid = tj.relation_id
    LEFT JOIN customer C ON C.customer_guid = w.customer_guid
    LEFT JOIN messagechange_info mi ON mi.workorderno = tj.order_no
    LEFT JOIN NY_RELATION_LIST mo ON mo.guid = mi.list_guid 
    AND mo.s1 = '1'
    LEFT JOIN sysc_objectivestatus sy ON TRIM ( sy.objectivestatus ) = TRIM ( w.objectivestatus )
    LEFT JOIN staff s ON s.staff_id = w.createdby
    LEFT JOIN staff ss ON ss.staff_id = w.handleby_id
    LEFT JOIN rolegroup r ON r.rolegroup_id = w.handlegroup_id
    LEFT JOIN ny_errorreason ne ON ne.relation_id = tj.relation_id
    LEFT JOIN i_continfo_elite i ON i.customerno = C.customerno 
    AND i.answertype = '0'
    LEFT JOIN i_continfo_elite ii ON ii.contno = mo.contno 
    AND ii.answertype = '0'
    LEFT JOIN ldcom x ON substr( i.managecom, 1, 4 ) = x.comcode
    LEFT JOIN ldcom xx ON substr( i.managecom, 1, 6 ) = xx.comcode
    LEFT JOIN ldcom xxx ON substr( i.managecom, 1, 8 ) = xxx.comcode
    LEFT JOIN NY_PARAMETERS np ON np.key_id = mi.projectname 
    AND np.Parent_ ID = 'zn_property' 
    AND np.Para_Type = 'CHANGE' 
    AND np.is_tocompany = '1'
    LEFT JOIN NY_PARAMETERS np1 ON np1.Para_Type = 'CHANGE_TYPE' 
    AND np1.key_id = mi.operate
    LEFT JOIN workorderstep3 w5 ON w5.workorder_guid = w.objective_guid 
    AND ( w5.from_stepidmap = 'B6O6K6' AND w5.workorderstepstatus != 'CLOSE' )
    LEFT JOIN workorderstep3 w6 ON w6.workorder_guid = w.objective_guid 
    AND ( w6.from_stepidmap = '3XJI2K' AND w6.workorderstepstatus != 'CLOSE' )
    LEFT JOIN (
    SELECT
      f.order_no,
      f.deal_date,
      f.trace_result 
    FROM
      fail_leadingin f 
    WHERE
      f.status = '1' 
      AND f.new_flag = '1' 
    ) v ON v.order_no = tj.order_no 
  WHERE
    1 = 1 
    AND w.createddate >= to_date( '2018-01-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss' ) 
    AND w.createddate <= to_date( '2021-01-01 00:00:0 1', 'yyyy-mm-dd hh24:mi:ss' ) /* and w.objectivestatus in (!(gdzt)) */
    
    AND w.map_id = '4SXFJI' /*and i.contno is not null*/
/*and ((substr(x.comcode, 1, length('8636')) in ('8636') and mi.cust_cont='cont') or x.comcode is null)*/
    
    AND (
      ( substr( x.comcode, 1, LENGTH ( 8636 ) ) IN ( '8636' ) AND mi.cust_cont = 'cont' ) 
      OR x.comcode IS NULL 
    ) 
    AND (
      w.handlegroup_id IN ( SELECT j.rolegroup_id FROM jg_distributor j WHERE substr( j.manacom, 1, LENGTH ( 8636 ) ) IN ( '8636' ) ) 
      OR w.handlegroup_id NOT LIKE'F%' 
    ) 
  GROUP BY
    sy.objectivestatusdescription,
    tj.order_no,
    s.staffname,
    w.createddate,
    w.modifieddate,
    C.customername,
    C.customerno,
    mi.chitno,
    mi.preservation,
    r.rolegroupdescription,
    ss.staffname,
    np.key_value,
    ( ca se WHEN ne.his_namereason IS NOT NULL THEN '?' ELSE'?' END ) 
  ) vcd
  LEFT JOIN ( SELECT COUNT ( 1 ) AS C, dy.order_no FROM fail_leadingin dy WHERE dy.status = '1' GROUP BY dy.order_no ) gd ON vcd.order_no = gd.order_noselect DISTINCT objectivestatusdescription,
  vcd.order_no,
  staffname1,
  createddate,
  modifieddate,
  customername,
  customerno, ???, ????, ????????, ????????, ?????, ??????, ???????, ??????, ?????, ?????, ?????, ????, ??, ???, ???, ??, ???, ????,
  gd.C, ???? 
FROM
  (
  SELECT DISTINCT
    sy.objectivestatusdescription AS objectivestatusdescription,
    tj.order_no AS order_no,
    s.staffname AS staffname1,
    w.createddate AS createddate,
    w.modifieddate AS modifieddate,
    C.customername AS customername,
    C.customerno AS customerno,
    mi.chitno AS ???,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT x.NAME ) ) AS ????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT xx.comcode ) ) AS ????????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT xx.NAME ) ) AS ????????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT xxx.NAME ) ) AS ?????,
    wm_concat ( DISTINCT '????' || np1.key_value || np.key_value || ', ' || mi.info ) AS ?????? ,
    wm_concat ( DISTINCT to_char( w5.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) || w5.comments ) AS ???????,
    wm_concat ( DISTINCT to_char( w6.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) || w6.comments ) AS ?????? ,
    r.rolegroupdescription AS ?????,
    ss.staffname AS ?????,
    ( CASE WHEN ne.his_namereason IS NOT NULL THEN '?' ELSE'?' END ) AS ?????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT i.salechnl ) ) AS ????,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', '???' ) AS ??,
    decode( wm_concat ( DISTINCT mi.cust_cont ), 'cont', wm_concat ( DISTINCT ii.address ), wm_concat ( DISTINCT i.address ) ) AS ???,
    decode(
      wm_concat ( DISTINCT mi.cust_cont ),
      'cont',
      wm_concat ( DISTINCT i.riskcode ),
      'cont',
      wm_concat ( DISTINCT ii.contno ) 
    ) AS ???,
    decode(
      wm_concat ( DISTINCT mi.cust_cont ),
      'cont',
      wm_concat ( DISTINCT i.telephone ),
      'cont',
      wm_concat ( DISTINCT ii.telephone ) 
    ) AS ??,
    mi.preservation AS ???,
    wm_concat ( DISTINCT v.deal_date || v.trace_result ) AS ????,
    np.key_value AS ???? 
  FROM
    tabcnyworkorder tj
    LEFT JOIN objective w ON w.objective_guid = tj.relation_id
    LEFT JOIN customer C ON C.customer_guid = w.customer_guid
    LEFT JOIN messagechange_info mi ON mi.workorderno = tj.order_no
    LEFT JOIN NY_RELATION_LIST mo ON mo.guid = mi.list_guid 
    AND mo.s1 = '1'
    LEFT JOIN sysc_objectivestatus sy ON TRIM ( sy.objectivestatus ) = TRIM ( w.objectivestatus )
    LEFT JOIN staff s ON s.staff_id = w.createdby
    LEFT JOIN staff ss ON ss.staff_id = w.handleby_id
    LEFT JOIN rolegroup r ON r.rolegroup_id = w.handlegroup_id
    LEFT JOIN ny_errorreason ne ON ne.relation_id = tj.relation_id
    LEFT JOIN i_continfo_elite i ON i.customerno = C.customerno 
    AND i.answertype = '0'
    LEFT JOIN i_continfo_elite ii ON ii.contno = mo.contno 
    AND ii.answertype = '0'
    LEFT JOIN ldcom x ON substr( i.managecom, 1, 4 ) = x.comcode
    LEFT JOIN ldcom xx ON substr( i.managecom, 1, 6 ) = xx.comcode
    LEFT JOIN ldcom xxx ON substr( i.managecom, 1, 8 ) = xxx.comcode
    LEFT JOIN NY_PARAMETERS np ON np.key_id = mi.projectname 
    AND np.Parent_ ID = 'zn_property' 
    AND np.Para_Type = 'CHANGE' 
    AND np.is_tocompany = '1'
    LEFT JOIN NY_PARAMETERS np1 ON np1.Para_Type = 'CHANGE_TYPE' 
    AND np1.key_id = mi.operate
    LEFT JOIN workorderstep3 w5 ON w5.workorder_guid = w.objective_guid 
    AND ( w5.from_stepidmap = 'B6O6K6' AND w5.workorderstepstatus != 'CLOSE' )
    LEFT JOIN workorderstep3 w6 ON w6.workorder_guid = w.objective_guid 
    AND ( w6.from_stepidmap = '3XJI2K' AND w6.workorderstepstatus != 'CLOSE' )
    LEFT JOIN (
    SELECT
      f.order_no,
      f.deal_date,
      f.trace_result 
    FROM
      fail_leadingin f 
    WHERE
      f.status = '1' 
      AND f.new_flag = '1' 
    ) v ON v.order_no = tj.order_no 
  WHERE
    1 = 1 
    AND w.createddate >= to_date( '2018-01-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss' ) 
    AND w.createddate <= to_date( '2021-01-01 00:00:0 1', 'yyyy-mm-dd hh24:mi:ss' ) /* and w.objectivestatus in (!(gdzt)) */
    
    AND w.map_id = '4SXFJI' /*and i.contno is not null*/
/*and ((substr(x.comcode, 1, length('8636')) in ('8636') and mi.cust_cont='cont') or x.comcode is null)*/
    
    AND (
      ( substr( x.comcode, 1, LENGTH ( 8636 ) ) IN ( '8636' ) AND mi.cust_cont = 'cont' ) 
      OR x.comcode IS NULL 
    ) 
    AND (
      w.handlegroup_id IN ( SELECT j.rolegroup_id FROM jg_distributor j WHERE substr( j.manacom, 1, LENGTH ( 8636 ) ) IN ( '8636' ) ) 
      OR w.handlegroup_id NOT LIKE'F%' 
    ) 
  GROUP BY
    sy.objectivestatusdescription,
    tj.order_no,
    s.staffname,
    w.createddate,
    w.modifieddate,
    C.customername,
    C.customerno,
    mi.chitno,
    mi.preservation,
    r.rolegroupdescription,
    ss.staffname,
    np.key_value,
    ( ca se WHEN ne.his_namereason IS NOT NULL THEN '?' ELSE'?' END ) 
  ) vcd
  LEFT JOIN ( SELECT COUNT ( 1 ) AS C, dy.order_no FROM fail_leadingin dy WHERE dy.status = '1' GROUP BY dy.order_no ) gd ON vcd.order_no = gd.order_no


SELECT
  DISTINCT  objectivestatusdescription, 
  vcd.order_no, staffname1, createddate, 
  modifieddate, customername, customerno, ???, ????, 
  ????????, ????????, ?????, ??????, ???????, ?????
  ?, ?????, ?????, ?????, ????, ??, ???, ???, ??, ?
  ??, ????, gd.C, ???? 
FROM
  (
    SELECT
      DISTINCT  sy.objectivestatusdescription AS 
      objectivestatusdescription, tj.order_no AS 
      order_no, s.staffname AS staffname1, 
      w.createddate AS createddate, w.modifieddate AS 
      modifieddate, C.customername AS customername, 
      C.customerno AS customerno, mi.chitno AS ???, 
      decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT x.NAME ) 
      )AS
      ????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT xx.comcode ) 
      )AS
      ????????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT xx.NAME ) 
      )AS
      ????????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT xxx.NAME ) 
      )AS
      ?????, wm_concat (
        DISTINCT '????' 
        || np1.key_value 
        || np.key_value 
        || ', ' 
        || mi.info 
      )AS
      ?????? , wm_concat (
        DISTINCT to_char
          ( w5.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) 
        || w5.comments 
      )AS
      ???????, wm_concat (
        DISTINCT to_char
          ( w6.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) 
        || w6.comments 
      )AS
      ?????? , r.rolegroupdescription AS ?????, 
      ss.staffname AS ?????, (
        CASE
          WHEN
            ne.his_namereason IS NOT NULL 
          THEN
            '?' 
          ELSE
            '?' 
        END
      )AS
      ?????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT i.salechnl ) 
      )AS
      ????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        '???' 
      )AS
      ??, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT ii.address ), wm_concat 
          ( DISTINCT i.address ) 
      )AS
      ???, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT i.riskcode ), 'cont', 
        wm_concat ( DISTINCT ii.contno )  
      )AS
      ???, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT i.telephone ), 'cont', 
        wm_concat ( DISTINCT ii.telephone )  
      )AS
      ??, mi.preservation AS ???, wm_concat 
        ( DISTINCT v.deal_date || v.trace_result ) AS ??
      ??, np.key_value AS ????  
    FROM
      tabcnyworkorder tj  
    LEFT JOIN
      objective w 
      ON w.objective_guid = tj.relation_id  
    LEFT JOIN
      customer C 
      ON C.customer_guid = w.customer_guid  
    LEFT JOIN
      messagechange_info mi 
      ON mi.workorderno = tj.order_no  
    LEFT JOIN
      NY_RELATION_LIST mo 
      ON mo.guid = mi.list_guid  
      AND mo.s1 = '1'  
    LEFT JOIN
      sysc_objectivestatus sy 
      ON TRIM ( sy.objectivestatus ) = TRIM 
        ( w.objectivestatus ) 
    LEFT JOIN
      staff s 
      ON s.staff_id = w.createdby  
    LEFT JOIN
      staff ss 
      ON ss.staff_id = w.handleby_id  
    LEFT JOIN
      rolegroup r 
      ON r.rolegroup_id = w.handlegroup_id  
    LEFT JOIN
      ny_errorreason ne 
      ON ne.relation_id = tj.relation_id  
    LEFT JOIN
      i_continfo_elite i 
      ON i.customerno = C.customerno  
      AND i.answertype = '0'  
    LEFT JOIN
      i_continfo_elite ii 
      ON ii.contno = mo.contno  
      AND ii.answertype = '0'  
    LEFT JOIN
      ldcom x 
      ON substr( i.managecom, 1, 4 ) = x.comcode  
    LEFT JOIN
      ldcom xx 
      ON substr( i.managecom, 1, 6 ) = xx.comcode  
    LEFT JOIN
      ldcom xxx 
      ON substr( i.managecom, 1, 8 ) = xxx.comcode  
    LEFT JOIN
      NY_PARAMETERS np 
      ON np.key_id = mi.projectname  
      AND np.Parent_ ID = 'zn_property'  
      AND np.Para_Type = 'CHANGE'  
      AND np.is_tocompany = '1'  
    LEFT JOIN
      NY_PARAMETERS np1 
      ON np1.Para_Type = 'CHANGE_TYPE'  
      AND np1.key_id = mi.operate  
    LEFT JOIN
      workorderstep3 w5 
      ON w5.workorder_guid = w.objective_guid  
      AND (
        w5.from_stepidmap = 'B6O6K6' AND 
        w5.workorderstepstatus != 'CLOSE' 
      )
    LEFT JOIN
      workorderstep3 w6 
      ON w6.workorder_guid = w.objective_guid  
      AND (
        w6.from_stepidmap = '3XJI2K' AND 
        w6.workorderstepstatus != 'CLOSE' 
      )
    LEFT JOIN
      (
        SELECT
          f.order_no, f.deal_date, f.trace_result  
        FROM
          fail_leadingin f  
        WHERE
          f.status = '1'  
          AND f.new_flag = '1'  
      )v
      ON v.order_no = tj.order_no  
    WHERE
      1 = 1  
      AND w.createddate >= to_date
        ( '2018-01-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss' )  
      AND w.createddate <= to_date(
        '2021-01-01 00:00:0 1', 'yyyy-mm-dd hh24:mi:ss' 
      )/* and w.objectivestatus in (!(gdzt)) */
      AND w.map_id = '4SXFJI' /*and i.contno is not null*/
      /*and ((substr(x.comcode, 1, length('8636')) in ('8636') and mi.cust_cont='cont') or x.comcode is null)*/
      AND (
        (
          substr( x.comcode, 1, LENGTH ( 8636 ) ) IN 
            ( '8636' ) AND mi.cust_cont = 'cont' 
        )
        OR x.comcode IS NULL  
      )
      AND (
        w.handlegroup_id IN (
          SELECT
            j.rolegroup_id 
          FROM
            jg_distributor j 
          WHERE
            substr( j.manacom, 1, LENGTH ( 8636 ) ) IN 
              ( '8636' ) 
        )
        OR w.handlegroup_id NOT LIKE'F%'  
      )
    GROUP BY
      sy.objectivestatusdescription, tj.order_no, 
      s.staffname, w.createddate, w.modifieddate, 
      C.customername, C.customerno, mi.chitno, 
      mi.preservation, r.rolegroupdescription, 
      ss.staffname, np.key_value, (
        ca se WHEN ne.his_namereason IS NOT NULL THEN '?' 
        ELSE'?' END 
      )
  )vcd
LEFT JOIN
  (
    SELECT
      COUNT ( 1 ) AS C, dy.order_no 
    FROM
      fail_leadingin dy 
    WHERE
      dy.status = '1' 
    GROUP BY
      dy.order_no 
  )gd
  ON vcd.order_no = gd.order_noselect DISTINCT 
  objectivestatusdescription, vcd.order_no, 
  staffname1, createddate, modifieddate, 
  customername, customerno, ???, ????, ????????, ??
  ??????, ?????, ??????, ???????, ??????, ?????, ??
  ???, ?????, ????, ??, ???, ???, ??, ???, ????, 
  gd.C, ???? FROM  (
    SELECT
      DISTINCT  sy.objectivestatusdescription AS 
      objectivestatusdescription, tj.order_no AS 
      order_no, s.staffname AS staffname1, 
      w.createddate AS createddate, w.modifieddate AS 
      modifieddate, C.customername AS customername, 
      C.customerno AS customerno, mi.chitno AS ???, 
      decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT x.NAME ) 
      )AS
      ????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT xx.comcode ) 
      )AS
      ????????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT xx.NAME ) 
      )AS
      ????????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT xxx.NAME ) 
      )AS
      ?????, wm_concat (
        DISTINCT '????' 
        || np1.key_value 
        || np.key_value 
        || ', ' 
        || mi.info 
      )AS
      ?????? , wm_concat (
        DISTINCT to_char
          ( w5.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) 
        || w5.comments 
      )AS
      ???????, wm_concat (
        DISTINCT to_char
          ( w6.modifieddate, 'yyyy-MM-dd hh24:mi:ss' ) 
        || w6.comments 
      )AS
      ?????? , r.rolegroupdescription AS ?????, 
      ss.staffname AS ?????, (
        CASE
          WHEN
            ne.his_namereason IS NOT NULL 
          THEN
            '?' 
          ELSE
            '?' 
        END
      )AS
      ?????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT i.salechnl ) 
      )AS
      ????, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        '???' 
      )AS
      ??, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT ii.address ), wm_concat 
          ( DISTINCT i.address ) 
      )AS
      ???, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT i.riskcode ), 'cont', 
        wm_concat ( DISTINCT ii.contno )  
      )AS
      ???, decode(
        wm_concat ( DISTINCT mi.cust_cont ), 'cont', 
        wm_concat ( DISTINCT i.telephone ), 'cont', 
        wm_concat ( DISTINCT ii.telephone )  
      )AS
      ??, mi.preservation AS ???, wm_concat 
        ( DISTINCT v.deal_date || v.trace_result ) AS ??
      ??, np.key_value AS ????  
    FROM
      tabcnyworkorder tj  
    LEFT JOIN
      objective w 
      ON w.objective_guid = tj.relation_id  
    LEFT JOIN
      customer C 
      ON C.customer_guid = w.customer_guid  
    LEFT JOIN
      messagechange_info mi 
      ON mi.workorderno = tj.order_no  
    LEFT JOIN
      NY_RELATION_LIST mo 
      ON mo.guid = mi.list_guid  
      AND mo.s1 = '1'  
    LEFT JOIN
      sysc_objectivestatus sy 
      ON TRIM ( sy.objectivestatus ) = TRIM 
        ( w.objectivestatus ) 
    LEFT JOIN
      staff s 
      ON s.staff_id = w.createdby  
    LEFT JOIN
      staff ss 
      ON ss.staff_id = w.handleby_id  
    LEFT JOIN
      rolegroup r 
      ON r.rolegroup_id = w.handlegroup_id  
    LEFT JOIN
      ny_errorreason ne 
      ON ne.relation_id = tj.relation_id  
    LEFT JOIN
      i_continfo_elite i 
      ON i.customerno = C.customerno  
      AND i.answertype = '0'  
    LEFT JOIN
      i_continfo_elite ii 
      ON ii.contno = mo.contno  
      AND ii.answertype = '0'  
    LEFT JOIN
      ldcom x 
      ON substr( i.managecom, 1, 4 ) = x.comcode  
    LEFT JOIN
      ldcom xx 
      ON substr( i.managecom, 1, 6 ) = xx.comcode  
    LEFT JOIN
      ldcom xxx 
      ON substr( i.managecom, 1, 8 ) = xxx.comcode  
    LEFT JOIN
      NY_PARAMETERS np 
      ON np.key_id = mi.projectname  
      AND np.Parent_ ID = 'zn_property'  
      AND np.Para_Type = 'CHANGE'  
      AND np.is_tocompany = '1'  
    LEFT JOIN
      NY_PARAMETERS np1 
      ON np1.Para_Type = 'CHANGE_TYPE'  
      AND np1.key_id = mi.operate  
    LEFT JOIN
      workorderstep3 w5 
      ON w5.workorder_guid = w.objective_guid  
      AND (
        w5.from_stepidmap = 'B6O6K6' AND 
        w5.workorderstepstatus != 'CLOSE' 
      )
    LEFT JOIN
      workorderstep3 w6 
      ON w6.workorder_guid = w.objective_guid  
      AND (
        w6.from_stepidmap = '3XJI2K' AND 
        w6.workorderstepstatus != 'CLOSE' 
      )
    LEFT JOIN
      (
        SELECT
          f.order_no, f.deal_date, f.trace_result  
        FROM
          fail_leadingin f  
        WHERE
          f.status = '1'  
          AND f.new_flag = '1'  
      )v
      ON v.order_no = tj.order_no  
    WHERE
      1 = 1  
      AND w.createddate >= to_date
        ( '2018-01-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss' )  
      AND w.createddate <= to_date(
        '2021-01-01 00:00:0 1', 'yyyy-mm-dd hh24:mi:ss' 
      )/* and w.objectivestatus in (!(gdzt)) */
      AND w.map_id = '4SXFJI' /*and i.contno is not null*/
      /*and ((substr(x.comcode, 1, length('8636')) in ('8636') and mi.cust_cont='cont') or x.comcode is null)*/
      AND (
        (
          substr( x.comcode, 1, LENGTH ( 8636 ) ) IN 
            ( '8636' ) AND mi.cust_cont = 'cont' 
        )
        OR x.comcode IS NULL  
      )
      AND (
        w.handlegroup_id IN (
          SELECT
            j.rolegroup_id 
          FROM
            jg_distributor j 
          WHERE
            substr( j.manacom, 1, LENGTH ( 8636 ) ) IN 
              ( '8636' ) 
        )
        OR w.handlegroup_id NOT LIKE'F%'  
      )
    GROUP BY
      sy.objectivestatusdescription, tj.order_no, 
      s.staffname, w.createddate, w.modifieddate, 
      C.customername, C.customerno, mi.chitno, 
      mi.preservation, r.rolegroupdescription, 
      ss.staffname, np.key_value, (
        ca se WHEN ne.his_namereason IS NOT NULL THEN '?' 
        ELSE'?' END 
      )
  )vcd
LEFT JOIN
  (
    SELECT
      COUNT ( 1 ) AS C, dy.order_no 
    FROM
      fail_leadingin dy 
    WHERE
      dy.status = '1' 
    GROUP BY
      dy.order_no 
  )gd
  ON vcd.order_no = gd.order_no

屠龙刀法4 —— SQL格式化

一个排版整齐的SQL能够让大家一目了然其逻辑结构，然而一个排版混乱的SQL光手动排版就会花费几分钟，而且可能还把层次关系排错了。
如下为一个从程序中获取的SQL，排版混乱，读懂其逻辑感觉要掉一层皮，但是有了我们DBCS屠龙刀，问题就迎刃而解了。

人工智能

DBCS工具能快速格式化混乱SQL语句，提升代码可读性。通过智能排版技术，自动对齐SQL关键字、表名和字段，解决复杂SQL语句难以阅读的问题。支持多表连接、子查询等复杂语法，大幅提高开发效率，是数据库开发人员的必备工具。

2026采购季 | AI焕新·智启新局

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

屠龙刀法4 —— SQL格式化-腾讯云开发者社区-腾讯云

屠龙刀法4 —— SQL格式化

屠龙刀法4 —— SQL格式化

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐