Shulou(Shulou.com)06/01 Report--

The first table

The second table

Final demand

Simulation creation statement:

Create table a (id number,name varchar2 (30), code varchar2 (30))

Insert into a values (1 recordings czbacci pencils A01 pencils A02 pas A03')

Select * from a

Create table b (code varchar2 (30), codename varchar2 (30))

Insert into b values ('A01','I')

Insert into b values ('A02' love')

Insert into b values ('A03', 'you')

Select * from b

Sql statement is written as follows:

Select

Id,name,code

(select LISTAGG (codename,',') WITHIN GROUP (ORDER BY codename)

From b

Where code in

(SELECT regexp_substr (a.code,'[^,] +', 1, LEVEL)

FROM dual

CONNECT BY LEVEL < length (a.code)

From a

Of course, there is not only one way to write it, but you can also use plsql to achieve this function.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.