Oracle 递归拼接字段

后台应用

                string GetLevelName_2 = @"SELECT LISTAGG(T.AREA_NAME, ‘ / ‘) WITHIN GROUP(ORDER BY LEVEL DESC) AS RESULT
  FROM PRODUCE_EQUIPMENT_AREA T
 START WITH T.ID = {0}
CONNECT BY PRIOR T.PARENT = T.ID
       and T.PARENT is not null";
                foreach (DataRow dr in v.Dt.Rows)
                {
                    if (StringUtil.isNotNullOrBlank(dr["EI_CLS"]))
                    {
                        dt = DbUtil.QueryDT(string.Format(GetLevelName_1, dr["EI_CLS"]));
                        if (dt != null)
                        {
                            dr.BeginEdit();
                            dr["EI_CLS2"] = dt.Rows[0]["RESULT"].ToString();
                            dr.EndEdit();
                        }
                    }
                }

Oracle 递归拼接字段

标签：orb   span   row   beginedit   name   format   level   class   orm