title: Copy entire values of 2 columns from one table to another ensuring the relationship
body: <p>I have a table <code>STUDENT</code> with columns <code>st_id,name,age,dept_name</code>. Now I want to create a new table <code>STUDENT_DESC</code> with columns <code>st_id,dept_name,st_desc</code>. So I need to copy all the values of <code>st_id</code> and <code>dept_name</code> to the newly created table <code>STUDENT_DESC</code>. I need to ensure relationship while copying <code>st_id</code> and <code>dept_name</code> , the <code>dept_name</code> should be corresponding to <code>st_id</code>.So how can I do it in PL/SQL?</p>