Hello guys,
I have a question about regular expressions. Here are a few names:
WITH T AS
(
SELECT 'Bill CLINTON' as name FROM dual UNION ALL
SELECT 'Christiano RONALDO' FROM dual UNION ALL
SELECT 'Barack Hussein OBAMA' FROM dual UNION ALL
SELECT 'JUAN JOSE Miguel Ange' FROM dual UNION ALL
SELECT 'Miguel Ange JUAN JOSE' FROM dual UNION ALL
SELECT 'RONALDO Christiano' FROM dual
)
SELECT name
FROM t;
I want to split this string. I want something like this
RESULT:
Bill CLINTON
Christiano RONALDO
Barack Hussein OBAMA
Miguel Ange JUAN JOSE
Miguel Ange JUAN JOSE
Christiano RONALDO
Is this possible? Any idea?
Thanks guys