随笔分类 - oracle
TRIG自动处理修改自己TRIG
摘要:create or replace procedure "MES_TABEL_LOG"(tabel_name in varchar2,creat_trigger in integer :=0)isPRAGMA AUTONOMOUS_TRANSACTION;--is owen pragram job binary_integer; i integer; m_sql varchar2(4000...
阅读全文
oracle 发邮件遇收信人不存在处理
摘要:loop OPEN get_mailid; M_MAILID_W:=null; LOOP FETCH get_mailid INTO m_mail_id; EXIT WHEN get_mailid%NOTFOUN...
阅读全文
浙公网安备 33010602011771号