oracle单引号转义字符

 create or replace procedure p_employee_hire
authid current_user
is
  vn_ctn number(2);
  STMT_SQL varchar2(500);
begin
   select count(*) into vn_ctn from user_all_tables a where a.table_name like upper('T_RESULT_INFO');
   if vn_ctn > 0 then
      execute immediate 'drop table T_RESULT_INFO'; 
   end if;
   execute immediate 'create table T_RESULT_INFO as select e.ename,e.job from emp e where e.job='||''''||'CLERK'||'''';
end ;