title: How to move one table data to another table using stored procedure
body: <p>There is one table say department in which data is present.</p>
  <pre><code>create table department(deptno number, deptname varchar2(50), deptloc varchar2(50));
  
  insert into department values(1,'A','X');
  insert into department values(2,'B','Y');
  insert into department values(3,'C','Z');
  
  select * from department;
  </code></pre>
  <p>I want to move this data to another table say Department_SP using stored procedure. Basically, I wanted to know how we will move the data from one table to another using certain conditions or filters that will be performed using the stored procedure. Just I want an idea of how this will be done. I would appreciate it if you guys have any examples like this then please share your views on this.</p>