Loading

[Oracle] Split on query

Roberto Salemi

Hi,

I have in my DB a column 'note', where the content should be:
"Buongiorno a tutti||Che splendida giornata"

I would write a query for extract two string:
- string1 = "Buongiorno a tutti"
- string2 = "che splendida giornata"
if the first part or second part of string is empty I return null..

My special char is the double pipe "||".

How can I implement it?

Thanks.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Roberto Salemi11y ago
I write this code:
SELECT
REGEXP_SUBSTR ('Buongiorno||Che splendida giornata', '[^||]+', 1, 1) AS string1,
REGEXP_SUBSTR ('Buongiorno||Che splendida giornata', '[^||]+', 1, 2) AS string2
FROM DUAL;

but if i have this case:
SELECT
REGEXP_SUBSTR ('Buongiorno||Che splendida giornata', '[^||]+', 1, 1) AS string1,
REGEXP_SUBSTR ('||Che splendida giornata', '[^||]+', 1, 2) AS string2
FROM DUAL;

it not works!