SQL & PL/SQL

Hello gurus,

Can i insert into a table by making use of with clause and select ??

something similar to this ...

     insert into test_table
      (with abc as 
          (select * from emp_tble
           where dept_no = 10
           )
         select * from abc;
   );          

     if not i would i do by making use of  with clause & select ... any example would be great !!


  

Thank you so much!!!