있습니다.

create view uvw_test
as
with tmp as (
 select idx =1
 union all
 select idx = idx + 1 from tmp
 where idx < 10)
select * from tmp