I am new to tera data and we are migrating from oracle to teradata. I have a query like
SELECT regexp_substr('A,B,C', '[^,]+', 1, level) from dual connect by level <= regexp_count('A,B,C',
Teradata support Standard SQL's WITH RECURSIVE instead of CONNECT BY.
But you don't need recursion to split a string, in TD14 there's STRTOK_SPLIT_TO_TABLE, e.g.
FROM TABLE (STRTOK_SPLIT_TO_TABLE(1,'A,B,C',',')
RETURNS (outkey INTEGER
,token VARCHAR(30) CHARACTER SET UNICODE)
) AS dt