This content has been marked as final.
Show 1 reply
-
1. Re: Split string comma separated - teiid query
rareddy Mar 14, 2018 9:47 AM (in response to cm.kumar)You can use TEXTTABLE for that for ex:
select x.* from TEXTTABLE('one,two,three' COLUMNS col string ROW DELIMITER ',' DELIMITER ':') as x
Since you are saying looping, I think you may be wanting to use this in a virtual stored procedure. Check the procedure language on how to cursor through results of select in a loop.