Oracle 语法

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 168 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/hwubin5/p/11010714.html

文章标签：

#数据库

本文详细介绍了在Oracle数据库中使用UPDATE FROM语句解决数据更新问题的方法，并提供了字段拼接的具体实现，包括如何创建树形结构的字段拼接，为数据库操作提供实用技巧。

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"