Split string in Hana without using user defined functions ?

[former_member565459]

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

[KonradZaleski · Accepted solution]

From my knowledge there is no built-in function for maintaining split of string.

Here you have similair threads:

https://archive.sap.com/discussions/thread/3482620

https://archive.sap.com/discussions/message/16631483#16631483

https://stackoverflow.com/questions/27709088/hana-split-string