WITH tb AS ( 
SELECT LEVEL AS num -- n tree
FROM DUAL
CONNECT BY LEVEL <= 4)
SELECT 
SUBSTR('AaaaaBbbbbCccccDdddd', (5 * (num - 1)) + 1, 5) AS abcd
FROM tb;