时间戳

首页 > 解决方案 > 在sql developer中集成2个代码

sql - 在sql developer中集成2个代码

问题描述

我在 Sqldeveloper / Oracle 我有一个问题我想集成 2 个代码我们可以帮助我吗？我想要这个代码：

`select codpro,
       regexp_substr(codrca_list, '[^,]+',1,1) as IndustriesConcerned1,
       regexp_substr(codrca_list, '[^,]+',1,2) as IndustriesConcerned2,
       regexp_substr(codrca_list, '[^,]+',1,3) as IndustriesConcerned3,
       regexp_substr(codrca_list, '[^,]+',1,4) as IndustriesConcerned4,
       regexp_substr(codrca_list, '[^,]+',1,5) as IndustriesConcerned5
 from (
  SELECT CODPRO, LISTAGG (CODRCA, ',') as codrca_list
    FROM (SELECT DISTINCT PRO.CODPRO, RCA.CODRCA
            FROM PRO
                 JOIN PRB ON PRO.MOTCLE = PRB.CODPRO
                 JOIN RCA ON PRB.codrca = RCA.codrca
           WHERE     RCA.typrca = 'UTI'
                 AND RCA.CODRCA <> 'LEGSEC'
                 AND RCA.CODRCA <> 'LOUSEC'
                 AND RCA.CODRCA <> 'LEGHUM'
                 AND RCA.CODRCA <> 'LOUHUM')
GROUP BY codpro);`

在这段代码中：

`SELECT 
    PRO.CODPRO as SKU,
    PRO.MOTCLE AS PARENTPRODUCTSKU,
    MAX(CASE WHEN FAM.CODEFAM = PRO.FAMPRO THEN FAM.LIBFAM END) AS MarketNomLab1,
    MAX(CASE WHEN FAM.CODESFA = PRO.SFAPRO THEN FAM.LIBFAM END) AS MarketNomLab2,
    MAX(CASE WHEN FAM.CODESSF = PRO.SSFPRO THEN FAM.LIBFAM END) AS MarketNomLab3,
    PRO.CODPRO AS ProductName,
    AA_PRODUIT.NBRE_00 AS QuantityITS,
    AA_PRODUIT.NBRE_01 AS QuantityITC,
    PRO.GENCOD AS "GTI/EAN",
    AA_PRODUIT.GENCOD_00 AS "GTIN/EAN Sachet",
    AA_PRODUIT.GENCOD_01 AS "GTIN/EAN Carton",
    PRO.CODZN7 AS CountryOrigin,
    PRO.CODUNI AS TypeOfPkgList,
    PRO.CODZN10 AS "EPI CLASS",
    PRO.CODDOU AS CustomsCode,
    PRO.LONGUE AS DepthOTC,
    PRO.HAUTE AS HeightOTC,
    PRO.VOLUME AS VolumeOTC,
    PRO.POIDS AS WeightOTC,
    PRO.LARGE AS WidthOTC,
    PRO.DESIGN5||PRO.DESIGN6 AS ProductCommArg1
FROM PRO 
JOIN PRB ON PRO.CODPRO = PRB.CODPRO 
JOIN FAM ON PRB.CODSOC = FAM.CODSOC 
JOIN AA_PRODUIT ON PRO.CODPRO=AA_PRODUIT.CODPRO
WHERE fam.typtie='PRO' AND (FAM.CODEFAM = PRO.FAMPRO OR FAM.CODESFA = PRO.SFAPRO OR FAM.CODESSF = PRO.SSFPRO)
GROUP BY PRO.CODPRO, PRO.MOTCLE, PRO.CODPRO, AA_PRODUIT.NBRE_00, AA_PRODUIT.NBRE_01,PRO.GENCOD, AA_PRODUIT.GENCOD_00, AA_PRODUIT.GENCOD_01, PRO.CODZN7, PRO.CODUNI, PRO.CODZN10, PRO.CODDOU, PRO.LONGUE, PRO.HAUTE, PRO.VOLUME,PRO.POIDS, PRO.LARGE, PRO.DESIGN5||PRO.DESIGN6;`

我想整合这两个例子：

在此处输入图像描述 在此处 输入图像描述

你有解决方案吗 ？因为我不知道该怎么做我提前谢谢你

标签： sqloracle

解决方案

推荐阅读