How to insert value from cte into oracle table?

Question

Oracle

I have a table in which I need to insert values ​​from cte, I use this syntax:

with cte as(
select *
from a
)
insert into b select * from cte where rnk=1;

He answers me missing select and says that there is no cte plate. How can the problem be solved?

Answer 1

Probably something like this, the with construction should be immediately before the select

insert into b
with cte as (select * from a)
 select * 
from cte 
where rnk=1;