1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| WITH wrk_matable AS (
SELECT 'cle' AS monchamps FROM dual
UNION ALL
SELECT 'suis' AS monchamps FROM dual
UNION ALL
SELECT 'invalide' AS monchamps FROM dual
)
SELECT monchamps
FROM wrk_matable
WHERE monchamps IN (
SELECT SUBSTR ( ','||REPLACE(trim(' je suis la cle '), ' ', ',')||','
, INSTR ( ','||REPLACE(trim(' je suis la cle '), ' ', ',')||',', ',', 1, LEVEL ) + 1
, instr (','||REPLACE(trim(' je suis la cle '), ' ', ',')||',', ',', 1, level+1)
- instr (','||REPLACE(trim(' je suis la cle '), ' ', ',')||',', ',', 1, level) -1 )
FROM dual
CONNECT BY LEVEL <= length(TRIM (' je suis la cle ')) - LENGTH(REPLACE(TRIM(' je suis la cle '), ' ', ''))+1) |
Partager