i'm using 'With Recursive' to fetch required result set, i need to insert this result set into another table. Please let me know how we can do this.
I tried below syntax, but it's not working,
with recursive <recursive_name>
(select column list)
as
(
select * from seed table