i have problem convert script oracle postgres:
with q ( select 'abcde' str dual) select 'test' wl_id ,substr(str, level, 1) supply_mode_id q connect level < length(q.str) + 1; i tried in postgres:
with recursive t(n) (select 'test', substring('abcde', 1, 1) union select 'test', substring('abcde', n+1,1) t n<length('abcde') ) select * t i have error :
error: operator not exist: text + integer
i don't know how return same result in oracle.
Comments
Post a Comment