title: SQL/ Function Loops
body: <p>I am trying to write a function that will run until something is inserted into my table. I want it to check ever 10 seconds for an entry giving me an output message. </p>
  
  <p>i know i will have to use the dbms_lock.sleep(10) and a while loop.</p>
  
  <p>but any other advice would be very helpful.</p>