1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
UPDATE table_y
SET champ1_table_Y = (
with t as (
select '1' as ID, '5W40;10W40;10W50;5W30' as NORMES
from DUAL --(TABLE_X)
)
SELECT NORMES FROM (
select t.ID, x.column_value as NORMES
from t
cross join table(
cast(multiset(
select substr( ';'||NORMES||';',
instr( ';'||NORMES||';', ';', 1, rownum )+1,
instr( ';'||NORMES||';', ';', 1, rownum+1 )
-instr( ';'||NORMES||';', ';', 1, rownum )-1
)
from dual
connect by level <= length(NORMES)-length(replace(NORMES,';',''))+1
) as sys.odcivarchar2list )
) x ) as Reselect
WHERE champ1_table_Y = Reselect.ID
)
WHERE table_y.champ3 = 'choucroute' |
Partager