title: plsql - cursor to see if a record already exists
body: <p>Using a pl sql procedure to insert from a temporary table into separate tables
  how do I check if a record is duplicated by using an if statement </p>
  
  <ol>
  <li>if it doesnt exist then insert  </li>
  <li>if does exist then show the duplicate in a message (dbms_output.put_line) and continue in the loop with the other records</li>
  </ol>
  
  <p>temp table: </p>
  
  <pre><code>create table temp_table
  (job title varchar2(20)
  ,empname varchar2(30));
  </code></pre>
  
  <p>i have a job table with <code>job_id</code>, <code>job_title</code> 
  i have an employee table with <code>empid</code>, <code>empname</code>, <code>jobid</code></p>