title: PL/SQL Triggers
body: <p>I am using these tables:</p>
  
  <ul>
  <li>flights (flno, origin, destination, distance, departs, arrives, price)</li>
  <li>aircraft (aid, aname, crusingrange) </li>
  <li>employees (eid, ename, salary)</li>
  <li>certified (eid,aid)</li>
  </ul>
  
  <p>and I need to create a trigger that displays a warning when inserting an employee with "666" anywhere in his/her name.</p>
  
  <p>This is what I came up with so far; I am lost with the rest of it.</p>
  
  <pre><code>set serveroutput on
  create or replace trigger emp_warning
  before insert
  on employees
  for each row
  declare
   v_name;
  begin
   select e.ename into v_ename
   from employees e
  </code></pre>