I need a solution using only oracle sql query
Input two static symbol ‘A’ and ‘B’ n – number
Output if N=3 must give all combination using this symbols
AAA AAB ABA BAA …
Output if N=4 must give all combination using this symbols
AAAA AAAB AABA ABAA …
Advertisement
Answer
Old style connect by
hierarchical query
with i(s) as
(
SELECT 'A' FROM DUAL UNION ALL
SELECT 'B' FROM DUAL
)
select replace(s, ' ', '') s
from (
select SYS_CONNECT_BY_PATH(s,' ') s, level l
from i
connect by level <= 4
) t
where l = 4