Skip to Content
0
Dec 17, 2018 at 08:08 AM

Split string in Hana without using user defined functions ?

276 Views

Is it possiible to split a comma separated string in Hana into rows without using a user defined function.

Something like this from oracle :

 SELECT DISTINCT REGEXP_SUBSTR ('23,34,45,56','[^,]+',1,LEVEL) as "token"
FROM   DUAL
CONNECT BY REGEXP_SUBSTR ('23,34,45,56','[^,]+',1,LEVEL) IS NOT NULL
order by 1