hihi

Hello, everyone!

CREATE OR REPLACE PROCEDURE author_sel_regexp_like (
   cv_author IN OUT SYS_REFCURSOR)
IS
BEGIN

   OPEN cv_author FOR
   SELECT id, first_name, last_name
   FROM authors
   WHERE REGEXP_LIKE(last_name, '^har(d|t)man$', 'i');

EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.PUT_LINE(sqlerrm);
END;
/