有这样一个需求,就是一个文本中,需要找出指定格式的字符串进行指定的替换,当前我的真实需求是,一个sql创建触发器的文本,我需要将所有的 包含 TB_SYS 的表名后面添加一个 “_NEW”字符串!
例如:
Creating trigger TRG_TB_SYSFILE 替换后 变成Creating trigger TRG_TB_SYSFILE_NEW
正则表达式:(TB_SYS[^\.]+\b)
替换表达式:$1_NEW
说明:
$0,其中$0表示正则匹配的整个最大字符串值。
$1,表示在查找的表达式中查找到的第一个()指定的字符。
$2,表示在查找的表达式中查找到的第二个()指定的字符。
...
$n,表示在查找的表达式中查找到的第n个()指定的字符。
特别注意:这里替换的时候,只能手动点击一个一个替换,不能全部一次替换!!!
附 图片中实际操作文本:
-------------------------------------------- Export file for user DZDA ---- Created by ym on /1/23, 16:39:02 --------------------------------------------set define offspool dzda_sys_trg.logpromptprompt Creating trigger TRG_TB_SYSFILEprompt ===============================promptcreate or replace trigger dzda.TRG_TB_SYSFILEbefore insert ON TB_SYSFILEfor each rowwhen (new.id is null)beginselect SEQ_TB_SYSFILE.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSIPBLACKprompt ==================================promptcreate or replace trigger dzda.trg_tb_sysipblackbefore insert ON tb_sysipblackfor each rowwhen (new.id is null)beginselect seq_tb_sysipblack.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSLOGINLOGprompt ===================================promptcreate or replace trigger dzda.trg_tb_sysloginlogbefore insert ON tb_sysloginlogfor each rowwhen (new.id is null)beginselect seq_tb_sysloginlog.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSLOGOPERATIONprompt =======================================promptcreate or replace trigger dzda.trg_tb_syslogoperationbefore insert ON tb_syslogoperationfor each rowwhen (new.id is null)beginselect seq_tb_syslogoperation.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSLOGSETTINGprompt =====================================promptcreate or replace trigger dzda.trg_tb_syslogsettingbefore insert ON tb_syslogsettingfor each rowwhen (new.logid is null)beginselect seq_tb_syslogsetting.nextval into :new.logid from dual;end;/promptprompt Creating trigger TRG_TB_SYSLOGSETTINGDETAILprompt ===========================================promptcreate or replace trigger dzda.trg_tb_syslogsettingdetailbefore insert ON tb_syslogsettingdetailfor each rowwhen (new.id is null)beginselect seq_tb_syslogsettingdetail.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSMENUprompt ===============================promptcreate or replace trigger dzda.TRG_TB_SYSMENU beforeinsert on TB_SYSMENU for each rowwhen (new.id is null)beginselect SEQ_TB_SYSMENU.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSORGANIZATIONprompt =======================================promptcreate or replace trigger dzda.trg_tb_SysOrganizationbefore insert ON tb_SysOrganizationfor each rowwhen (new.id is null)beginselect seq_tb_SysOrganization.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSPARAMETERprompt ====================================promptcreate or replace trigger dzda.trg_tb_sysparameterbefore insert ON tb_sysparameterfor each rowwhen (new.id is null)beginselect seq_tb_sysparameter.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSPERMISSIONSprompt ======================================promptcreate or replace trigger dzda.trg_tb_syspermissionsbefore insert ON tb_syspermissionsfor each rowwhen (new.id is null)beginselect seq_tb_syspermissions.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSPLUGINprompt =================================promptcreate or replace trigger dzda.trg_tb_syspluginbefore insert ON tb_syspluginfor each rowwhen (new.id is null)beginselect seq_tb_sysplugin.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSROLEprompt ===============================promptcreate or replace trigger dzda.trg_tb_sysrolebefore insert ON tb_sysrolefor each rowwhen (new.id is null)beginselect seq_tb_sysrole.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSROLEPERMISSIONSprompt ==========================================promptcreate or replace trigger dzda.trg_tb_sysrolepermissionsbefore insert ON tb_sysrolepermissionsfor each rowwhen (new.id is null)beginselect seq_tb_sysrolepermissions.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYSUSERprompt ===============================promptcreate or replace trigger dzda.trg_tb_sysuserbefore insert ON tb_sysuserfor each rowwhen (new.id is null)beginselect seq_tb_sysuser.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYS_ERROR_LOGprompt =====================================promptcreate or replace trigger dzda.TRG_TB_SYS_ERROR_LOG beforeinsert on TB_SYS_ERROR_LOG for each rowwhen (new.id is null)beginselect SEQ_TB_SYS_ERROR_LOG.nextval into :new.id from dual;end;/promptprompt Creating trigger TRG_TB_SYS_LWLOGprompt =================================promptcreate or replace trigger dzda.TRG_TB_SYS_LWLOG beforeinsert on TB_SYS_LWLOG for each rowwhen (new.id is null)beginselect SEQ_TB_SYS_LWLOG.nextval into :new.id from dual;end;/spool off