Oracle 数据库的替代变量问题（即 set define off/on 的用法）
生活随笔
收集整理的這篇文章主要介紹了
Oracle 数据库的替代变量问题（即 set define off/on 的用法）
小編覺得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
在 SQL*Plus 中默認(rèn)的 & 表示替代變量，也就是說，只要在命令中出現(xiàn)該符號(hào)，SQL*Plus 就會(huì)要你輸入替代值。這就意味著你無法將一個(gè)含有該符號(hào)的字符串輸入數(shù)據(jù)庫或賦給變量，如字符串 SQL&Plus 系統(tǒng)會(huì)理解為以 SQL 打頭的字符串，它會(huì)提示你輸入替代變量 Plus的值，如果你輸入 ABC，則最終字符串轉(zhuǎn)化為 SQLABC。
set define off 則關(guān)閉該功能，& 將作為普通字符，如上例，最終字符就為 SQL&Plus，set define on 開啟替代變量功能。set define * 將默認(rèn)替代變量標(biāo)志符該為 * (也可以設(shè)為其它字符)。
經(jīng)常會(huì)用在 SQL 腳本文件中，如下：
set define off; delete from HYT2PFHN.T_PF_OP where opid='A72A268A2AE9BD44366EDB5B59F53019'; insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME) values ('A72A268A2AE9BD44366EDB5B59F53019', '8DD3171CE0E8439FBE1B8970880931D9', '1', '函件管理', 16, 'hyt2/images/toolbar/filing.gif', '6F2F48352C9A930FB8697BBEEE0CF4A2', 'PERID=[RESULT1.PERID.1,1]', '0', 2.0130821023702E16);delete from HYT2PFHN.T_PF_WINDOW where windowid='6F2F48352C9A930FB8697BBEEE0CF4A2'; insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME) values ('6F2F48352C9A930FB8697BBEEE0CF4A2', '運(yùn)政系統(tǒng)', '函件管理', '', '', '', 'F8A586C5D3FC573D2DDF194317650136', '0', 2.01308200757305E16);delete from HYT2PFHN.T_PF_OP where opid='C7EB7481DB92FFCF60D799A7CF336B8D'; insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME) values ('C7EB7481DB92FFCF60D799A7CF336B8D', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '制作函件', 1, 'hyt2/images/toolbar/add.png', '6FD602DE6C1B2A01F40E5490E75A5E98', 'PERID=[url.PERID]'||'&'||'opmethod=valPerStatus', '0', 2.01308210928291E16);delete from HYT2PFHN.T_PF_OP where opid='A9667DD77B51F931E9C3ADD2DD40B700'; insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME) values ('A9667DD77B51F931E9C3ADD2DD40B700', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '詳情', 2, '/hyt2/images/toolbar/detail.png', '60FF0FD1012712DF9922BD74434B92D1', 'DOID=[RESULT1.LETTERID.1,1] ', '0', 2.01308210954171E16);delete from HYT2PFHN.T_PF_OP where opid='CAAB3D3ABB0539E7B695687574DF3CCC'; insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME) values ('CAAB3D3ABB0539E7B695687574DF3CCC', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '打印', 3, 'hyt2/images/toolbar/print.gif', 'AAFD41259C425044072DE919131111F7', 'action=fzrtmis.hztech.middle.per.AppPer,printLetter,web'||'&'||'mouldId=lineLetter'||'&'||'DOID='||'&'||'opmethod=printWitness', '0', 2.01308220310548E16);delete from HYT2PFHN.T_PF_OP where opid='9424219486E854CE974A52463AD6917F'; insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME) values ('9424219486E854CE974A52463AD6917F', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '修改', 4, 'hyt2/images/toolbar/edit.png', '3F0CC8E075BACF71456CBA37BFCBF573', 'DOID=[RESULT1.LETTERID.1,1] ', '0', 2.01308210954269E16);delete from HYT2PFHN.T_PF_OP where opid='657B34D7B3DC84F9EE65EAE9EBD7735E'; insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME) values ('657B34D7B3DC84F9EE65EAE9EBD7735E', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '刪除', 5, 'hyt2/images/toolbar/del.png', 'CB34650CFA8B689E966E8A39E13D87B8', 'action=fzrtmis.hztech.middle.per.AppPer,deleteLetter'||'&'||'DOID='||'&'||'opmethod=del', '0', 2.01308211229182E16);delete from HYT2PFHN.T_CF2_MAIN where code='F8A586C5D3FC573D2DDF194317650136'; insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', '1', '', '', '', '', '', '/hyt2/jsp/scripts/fzrtmis/permission/accept.js', '0', '', '0', '', '', '', '', '', '', 2.01308210914136E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', 'TITLE', '函件標(biāo)題', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308210914136E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', 'RECEIVEORG', '接收機(jī)構(gòu)', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '0', '1', 2, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308210914136E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', 'LETTERNUM', '發(fā)函函號(hào)', '', '1', '1', '1', '', '', '', '', '0', '0', 3, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308210914136E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', 'CREDATE', '發(fā)函日期', '', '1', '1', '6', '', '', '', '', '0', '0', 1, '0', '', '', '0', 4, '', '', '', '', '', '', '', '', 2.01308210914136E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', 'BTNQUERY', '', '', '1', '1', 'G', '', '', '', '', '0', '0', 2, '0', '1', '查詢', '0', 5, '', 'οnclick="defaultQuery(this,''$SYS_WEB_PATH/platform/pages/common/subcommfunc2.jsp?action=XML.LINE.queryLetters'||'&'||'ISONEPAGE=0'||'&'||'COLWD=,350,,,,,110,230'||'&'||'FROZENCOL=1'||'&'||'ISAUTO=1'||'&'||'$URL_PARAMETER'',''RESULT1'')"', '', '', '', '', '', '', 2.01308210914136E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('F8A586C5D3FC573D2DDF194317650136', 'RESULT1', '*00*', '', '1', '-1', 'K', '', 'RESULT1', '/platform/pages/common/subcommfuncblank.jsp', '', '0', '0', 1, '0', '', '', '0', 6, '', '', '-1', '', '', '', '', '', 2.01308210914136E16);delete from HYT2PFHN.T_PF_WINDOW where windowid='6FD602DE6C1B2A01F40E5490E75A5E98'; insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME) values ('6FD602DE6C1B2A01F40E5490E75A5E98', '運(yùn)政系統(tǒng)', '函件制作', '', '', '', '631B246C1280E52F731A3503DF55BA8E', '0', 2.01308210242304E16);delete from HYT2PFHN.T_CF2_MAIN where code='631B246C1280E52F731A3503DF55BA8E'; insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', '1', '', '', '', '', '', '', '0', '', '0', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'V1', '函件基本信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'TITLE', '函件標(biāo)題', '', '1', '2,450', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'LETTERNUM', '發(fā)函函號(hào)', '', '1', '1,150', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'RECEIVEORG', '接收機(jī)構(gòu)', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '1', '0', 2, '0', '', '', '0', 4, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'RECIPIENT', '收件人', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 5, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'SENDORG1', '發(fā)函機(jī)構(gòu)', '***顯示給用戶看而已', '1', '1,150', '1', '', '', '', '', '1', '0', 3, '0', '7', '$SYSDEPNAME', '0', 6, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'SENDORG', '', '***實(shí)際保存到表中的', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '7', '$SYSDEPCODE', '0', 7, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'SENDER', '發(fā)函人', '', '1', '1', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 8, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'PHONE', '發(fā)函人聯(lián)系電話', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 9, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'FAX', '發(fā)函人傳真', '', '1', '1', '1', '', '', '', '', '1', '0', 3, '0', '', '', '0', 10, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'CONTENTOFLETTER', '函件內(nèi)容', '', '1', '-1,,150', 'F', '', '', '', '', '1', '0', 1, '0', '', '', '0', 11, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'V2', '收件人回復(fù)信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 12, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'ANSWER', '回復(fù)人', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 13, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'REPLYDATE', '回復(fù)日期', '', '1', '1', '6', '', '', '', '', '0', '0', 2, '0', '', '', '0', 14, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'AGREE', '是否同意', '', '1', '1,65', 'L', '', '', 'SELECT '' '' AS CODE,'' '' AS NAME FROM DUAL UNION ALL SELECT ''1'' AS CODE, ''同意'' AS NAME FROM DUAL UNION ALLSELECT ''2'' AS CODE, ''不同意'' AS NAME FROM DUAL ', '', '0', '0', 3, '0', '', '', '0', 15, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'CONTENTOFREPLY', '回復(fù)內(nèi)容', '', '1', '-1,,150', 'F', '', '', '', '', '0', '0', 1, '0', '', '', '0', 16, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'PERID', '許可申請(qǐng)ID', '', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '2', 'PERID', '0', 17, '', '', '', '', '', '', '', '', 2.01308210908195E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('631B246C1280E52F731A3503DF55BA8E', 'BTNSAVE', '', '', '1', '-1', 'G', '', 'BTNSAVE', '', 'function save(){ if(formValidate()){ ARSNew("business","fzrtmis.hztech.middle.per.AppPer,addLetter",getDefaultXML(),"saveWithClosePageImpl"); }}', '0', '0', 0, '0', '1', '保 存', '0', 18, '', 'οnclick="save();"', 'TOOLBARBUTTON', '', '', '', '', '', 2.01308210908195E16);delete from HYT2PFHN.T_PF_WINDOW where windowid='60FF0FD1012712DF9922BD74434B92D1'; insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME) values ('60FF0FD1012712DF9922BD74434B92D1', '運(yùn)政系統(tǒng)', '函件詳情', '', '', '', '800F35387B7830C7A83739ECAAAC1703', '0', 2.01308200810562E16);delete from HYT2PFHN.T_CF2_MAIN where code='800F35387B7830C7A83739ECAAAC1703'; insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', '1', '', '5', '$PRDLINE.LETTERS:LETTERID[$DOID]', '', '', '', '0', '', '0', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'V1', '函件基本信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'TITLE', '函件標(biāo)題', '', '1', '2,450', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'LETTERNUM', '發(fā)函函號(hào)', '', '1', '1,150', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'RECEIVEORG', '接收機(jī)構(gòu)', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '1', '0', 2, '0', '7', '$INITFLD_RECEIVEORG###[DEPCODE(INITFLD_RECEIVEORG)]', '0', 4, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'RECIPIENT', '收件人', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 5, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'SENDORG', '發(fā)函機(jī)構(gòu)', '', '1', '1,150', '1', '', '', '', '', '0', '1', 3, '0', '7', '$SYSDEPNAME', '0', 6, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'SENDER', '發(fā)函人', '', '1', '1', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 7, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'PHONE', '發(fā)函人聯(lián)系電話', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 8, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'FAX', '發(fā)函人傳真', '', '1', '1', '1', '', '', '', '', '1', '0', 3, '0', '', '', '0', 9, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'CONTENTOFLETTER', '函件內(nèi)容', '', '1', '-1,,150', 'F', '', '', '', '', '1', '0', 1, '0', '', '', '0', 10, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'V2', '收件人回復(fù)信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 11, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'ANSWER', '回復(fù)人', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 12, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'REPLYDATE', '回復(fù)日期', '', '1', '1', '6', '', '', '', '', '0', '0', 2, '0', '', '', '0', 13, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'AGREE', '是否同意', '', '1', '1,65', 'L', '', '', 'SELECT '' '' AS CODE,'' '' AS NAME FROM DUAL UNION ALL SELECT ''1'' AS CODE, ''同意'' AS NAME FROM DUAL UNION ALLSELECT ''2'' AS CODE, ''不同意'' AS NAME FROM DUAL', '', '0', '0', 3, '0', '', '', '0', 14, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'CONTENTOFREPLY', '回復(fù)內(nèi)容', '', '1', '-1,,150', 'F', '', '', '', '', '0', '0', 1, '0', '', '', '0', 15, '', '', '', '', '', '', '', '', 2.01308211058508E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('800F35387B7830C7A83739ECAAAC1703', 'PERID', '許可申請(qǐng)ID', '', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '2', 'PERID', '0', 16, '', '', '', '', '', '', '', '', 2.01308211058508E16);delete from HYT2PFHN.T_PF_WINDOW where windowid='3F0CC8E075BACF71456CBA37BFCBF573'; insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME) values ('3F0CC8E075BACF71456CBA37BFCBF573', '運(yùn)政系統(tǒng)', '修改函件', '', '', '', 'B9CD4E88AC79A529E6CCAB98174E367A', '0', 2.01308211110118E16);delete from HYT2PFHN.T_CF2_MAIN where code='B9CD4E88AC79A529E6CCAB98174E367A'; insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', '1', '', '5', '$PRDLINE.LETTERS:LETTERID[$DOID]', '', '', '', '0', '', '0', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'V1', '函件基本信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'TITLE', '函件標(biāo)題', '', '1', '2,450', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'LETTERNUM', '發(fā)函函號(hào)', '', '1', '1,150', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'RECEIVEORG', '接收機(jī)構(gòu)', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '1', '0', 2, '0', '7', '$INITFLD_RECEIVEORG###[DEPCODE(INITFLD_RECEIVEORG)]', '0', 4, '', '', 'ALLREAD', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'RECIPIENT', '收件人', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 5, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'SENDORG1', '發(fā)函機(jī)構(gòu)', '***顯示給用戶看而已', '1', '1,150', '1', '', '', '', '', '1', '0', 3, '0', '7', '$SYSDEPNAME', '0', 6, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'SENDORG', '', '***實(shí)際保存到表中的', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '7', '$SYSDEPCODE', '0', 7, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'SENDER', '發(fā)函人', '', '1', '1', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 8, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'PHONE', '發(fā)函人聯(lián)系電話', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 9, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'FAX', '發(fā)函人傳真', '', '1', '1', '1', '', '', '', '', '1', '0', 3, '0', '', '', '0', 10, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'CONTENTOFLETTER', '函件內(nèi)容', '', '1', '-1,,150', 'F', '', '', '', '', '1', '0', 1, '0', '', '', '0', 11, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'V2', '收件人回復(fù)信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 12, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'ANSWER', '回復(fù)人', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 13, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'REPLYDATE', '回復(fù)日期', '', '1', '1', '6', '', '', '', '', '0', '0', 2, '0', '', '', '0', 14, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'AGREE', '是否同意', '', '1', '1,65', 'L', '', '', 'SELECT '' '' AS CODE,'' '' AS NAME FROM DUAL UNION ALL SELECT ''1'' AS CODE, ''同意'' AS NAME FROM DUAL UNION ALLSELECT ''2'' AS CODE, ''不同意'' AS NAME FROM DUAL', '', '0', '0', 3, '0', '', '', '0', 15, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'CONTENTOFREPLY', '回復(fù)內(nèi)容', '', '1', '-1,,150', 'F', '', '', '', '', '0', '0', 1, '0', '', '', '0', 16, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'PERID', '許可申請(qǐng)ID', '', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 17, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'LETTERID', '信函ID', '', '0', '1', '1', '', '', '', '', '0', '0', 2, '0', '', '', '0', 18, '', '', '', '', '', '', '', '', 2.01308211239313E16);insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME) values ('B9CD4E88AC79A529E6CCAB98174E367A', 'BTNSAVE', '', '', '1', '-1', 'G', '', 'BTNSAVE', '', 'function save(){ defaultSave(this,''fzrtmis.hztech.middle.per.AppPer,modifyLetter''); }', '0', '0', 0, '0', '1', '修 改', '0', 19, '', 'οnclick="save()"', 'TOOLBARBUTTON', '', '', '', '', '', 2.01308211239313E16);delete from hyt2pfhn.t_pf_rptmould where RPTMOULDID='EE84464BA38E2AEFD41DBB1FBF475831'; insert into t_pf_rptmould (RPTMOULDID, DEPCODE, USERCODE, MOULDTYPE, MOULDNAME, PRINTTYPE, MOULDXML, CREUSRCODE, CREDATE, CRETIME, EDIUSRCODE, EDIDATE, EDITIME, REMARK, PRINTERINFO, SYSOPERTIME) values ('EE84464BA38E2AEFD41DBB1FBF475831', '', 'fzrtmis', 'lineLetter', '客運(yùn)班線經(jīng)營行政許可征求意見函', '1', '<mould><RPTMOULDID>EE84464BA38E2AEFD41DBB1FBF475831</RPTMOULDID><PRDCODE /><DEPCODE /><USERCODE>fzrtmis</USERCODE><MOULDTYPE>lineLetter</MOULDTYPE><MOULDNAME>客運(yùn)班線經(jīng)營行政許可征求意見函</MOULDNAME><PRINTTYPE>1</PRINTTYPE><PRINTERINFO>缺省打印機(jī)</PRINTERINFO><PAGEXY>0,0</PAGEXY><MOULDCHAR>9</MOULDCHAR><PICINFO>/images/print_imges/appcmvecup.jpg#882#1163</PICINFO><PAGEINFO>0#0#1</PAGEINFO><REMARK /><WESTERNCHAR /><XMLID>XML.line.printLetter</XMLID><FIELDSET>TITLE#text2#text1#CREDATE#SENDER#FAX#PHONE#rectangle9#text10#text11#text12#text13#text14#text15#text16#text17#text18#text19#text20#BYWAYOF#BERTH#REGCTCTYPE#text24#PERVECNUM#TIMES#APPLYTYPE</FIELDSET><CNFIELDSET>客運(yùn)班線經(jīng)營行政許可征求意見函#編號(hào)：省際變更[2011]第110號(hào)#信件內(nèi)容#2011年08月16日#聯(lián)系人#傳真#聯(lián)系電話#矩形9#申請(qǐng)人#起訖站點(diǎn)名稱#途經(jīng)地#停靠站點(diǎn)#班車類型#里程# 班次#許可車輛數(shù)#許可申請(qǐng)類型#文本19#文本20#文本21#文本22#文本23#文本24#文本25#文本26#文本28</CNFIELDSET><FIELDTYPESET>1#1#1#1#1#1#1#3#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1</FIELDTYPESET><CONTENTSET>客運(yùn)班線經(jīng)營行政許可征求意見函#{h:LETTERNUM}#{h:CONTENTOFLETTER}#{h:CREDATE}#聯(lián)系人：{h:SENDER}#傳真：{h:FAX}#聯(lián)系電話：{h:PHONE}##申請(qǐng)人#起訖站點(diǎn)名稱#途經(jīng)地#停靠站點(diǎn)#班車類型#里程# 班次#許可車輛數(shù)#許可申請(qǐng)類型#{h:CLITNAME}#{h:STACLTNAME} 至 {h:ENDCLTNAME}####{h:SUMMIL}###</CONTENTSET><MARKSET>1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1</MARKSET><XSET>103#410#72#521#66#466#231#37#39#88#185#238#313#389#433#490#582#38#110#187#245#316#383#504#435#605</XSET><YSET>161#222#347#867#537#534#535#602#606#606#607#608#607#607#606#608#608#641#638#638#637#639#647#642#646#642</YSET><MAXWIDTHSET>0#0#600#0#600#600#600#677#0#0#0#0#0#0#0#0#0#60#60#60#60#60#60#60#60#60</MAXWIDTHSET><MAXHEIGHTSET>0#0#-10#0#0#0#0#768#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0</MAXHEIGHTSET><FONTNAMESET>宋體#宋體#宋體#宋體#宋體#宋體#宋體#2:15,85:10,20,10,15,15,10,10,20,20#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys</FONTNAMESET><FONTSIZESET>-35,700,0,0,700,0,0,0,134,3,2,1,2#-20,700,0,0,700,0,0,0,134,3,2,1,2#-20,700,0,0,700,0,0,0,134,3,2,1,2#-20,700,0,0,700,0,0,0,134,3,2,1,2#-19,700,0,0,700,0,0,0,134,3,2,1,2#-19,700,0,0,700,0,0,0,134,3,2,1,2#-19,700,0,0,700,0,0,0,134,3,2,1,2#0,1#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12</FONTSIZESET><ANGLESET>0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0</ANGLESET><TESTCASESET>客運(yùn)班線經(jīng)營行政許可征求意見函#編號(hào)：省際變更[2011]第110號(hào)# #2011年08月16日#測(cè)試7#測(cè)試8#測(cè)試9#測(cè)rectangle9#測(cè)試10#起訖站點(diǎn)名稱#途經(jīng)地#停靠站點(diǎn)#班車類型#里程#測(cè)試16#測(cè)試17#測(cè)試18#申請(qǐng)人#測(cè)試20#測(cè)試21#測(cè)試22#測(cè)試23#測(cè)試24#測(cè)試25#測(cè)試26#測(cè)試28</TESTCASESET></mould>', '', '', '', 'fzrtmis', '2013-08-22', '07:21:50', '', '缺省打印機(jī)', 2.0130822110334E16); set define on;alter table HYT2LINEHN.APPLINPER add(applytype varchar2(50));create table LETTERS (SYSOPERTIME NUMBER(25),REMARKDOC VARCHAR2(500),EDITIME VARCHAR2(100),EDIDATE VARCHAR2(100),EDIUSRCODE VARCHAR2(100),CRETIME VARCHAR2(100),CREDATE VARCHAR2(100),CREUSRCODE VARCHAR2(100),TITLE VARCHAR2(500),RECEIVEORG VARCHAR2(100),CONTENTOFLETTER VARCHAR2(2000),SENDORG VARCHAR2(100),SENDER VARCHAR2(100),PHONE VARCHAR2(100),FAX VARCHAR2(100),LETTERNUM VARCHAR2(100),PERID VARCHAR2(200),LETTERID VARCHAR2(200) not null,RECIPIENT VARCHAR2(100),ANSWER VARCHAR2(100),REPLYDATE VARCHAR2(100),CONTENTOFREPLY VARCHAR2(2000),AGREE VARCHAR2(50) )create table RELATIONSHIPOFLINEWITHVEHICLE (SYSOPERTIME NUMBER(25),REMARKDOC VARCHAR2(500),EDITIME VARCHAR2(100),EDIDATE VARCHAR2(100),EDIUSRCODE VARCHAR2(100),CRETIME VARCHAR2(100),CREDATE VARCHAR2(100),CREUSRCODE VARCHAR2(100),CMVECID VARCHAR2(200),PERID VARCHAR2(200) )總結(jié)
以上是生活随笔為你收集整理的Oracle 数据库的替代变量问题（即 set define off/on 的用法）的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 电脑宋体下载(宋体电脑字体)
- 下一篇： MacBook 如何通过命令终端进入 U