請問大佬，這種要怎么關聯？
uj5u.com熱心網友回復：
用regexp_substr拆開，再sys_connect_by_path連回去uj5u.com熱心網友回復：
WITH T1 AS (SELECT 'AA1' A,'00,01,03' B FROM DUAL UNION ALL
SELECT 'BB1' A,'01,02' B FROM DUAL UNION ALL
SELECT 'C1' A,'03' B FROM DUAL ),
T2 AS (
SELECT '00' A,'流動性貸款' B FROM DUAL UNION ALL
SELECT '01' A,'專案貸款' B FROM DUAL UNION ALL
SELECT '02' A,'定期貸款' B FROM DUAL UNION ALL
SELECT '03' A,'信托貸款' B FROM DUAL )
SELECT T1.A,T1.B,LISTAGG(T2.B,',') WITHIN GROUP (ORDER BY 1) SS
FROM T1 LEFT JOIN T2 ON T1.B LIKE '%'||T2.A||'%' GROUP BY T1.A,T1.B ORDER BY 1,2 ;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/16327.html
標籤：開發