Oracle 语法

Oracle中的 UPDATE FROM 解决方法

https://www.cnblogs.com/clds/p/6016639.html

 

字段拼接

'>' || a."MaterielCatalog_1_Code" || '>' || a."MaterielCatalog_2_Code" || '>' || a."MaterielCatalog_3_Code" || '>' as "MaterielCatalogFullCode",
    '>' || a."MaterielCatalog_1_Name" || '>' || a."MaterielCatalog_2_Name" || '>' || a."MaterielCatalog_3_Name" || '>' as "MaterielCatalogFullName",

树形结构拼接

SELECT  A."Id",
         A."Code",
         A."Name",
         A."FatherId",
         A."FinancialCode",
         A."SortOrder",
         A."Comment",
         A."CreateUser",
         A."CreateTime",
         A."UpdateUser",
         A."UpdateTime",
         CASE CONNECT_BY_ISLEAF WHEN 1 THEN 'FALSE' ELSE 'TRUE' END "HasChild",
         SYS_CONNECT_BY_PATH(A."Code", '>') || '>' "FullCode",
         SYS_CONNECT_BY_PATH(A."Name", '>') || '>' AS "FullName",
         Level AS "CatalogLevel"
    FROM ZTZS_ERPBASE."MaterialCatalog" A
   START WITH A."FatherId" IS NULL
 CONNECT BY PRIOR A."Id" = A."FatherId"
   ORDER SIBLINGS BY A."SortOrder"