CREATE VOLATILE TABLE vt_employee(emp_id) AS 
(
   emp_id INTEGER
) ON COMMIT PRESERVE ROWS;

WITH RECURSIVE rec_emp (emp_id) AS (
  SELECT emp_id
  FROM Table1
  WHERE emp_id = 10
 	UNION ALL
   SELECT t.emp_id
   FROM Table1 t, rec_emp r
   WHERE r.emp_id = t.Empid
)
INSERT INTO vt_employee
select emp_id from rec_emp;

WITH RECURSIVE rec_emp (emp_id) AS (
  SELECT emp_id
  FROM Table1
  WHERE emp_id = 10
 	UNION ALL
   SELECT t.emp_id
   FROM Table1 t, rec_emp r
   WHERE r.emp_id = t.Empid
) select * from rec_emp