📄 te.ins
字号:
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (524, 'TE', 'TESPEC.GDR', '1', ' --// Initialize record with default values. //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (523, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (522, 'TE', 'TESPEC.GDR', '1', ' FUNCTION ^{PLG>initrecfunc}^ (allnull IN BOOLEAN := FALSE) RETURN {PLG>>tableRT};');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (521, 'TE', 'TESPEC.GDR', '1', ' --// Initialize record with default values. //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (520, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (519, 'TE', 'TESPEC.GDR', '1', '--// Insert Processing //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (518, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (517, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (516, 'TE', 'TESPEC.GDR', '1', '--// NO UPDATE PROCESSING; only primary key columns! //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (515, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (514, 'TE', 'TESPEC.GDR', '1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (513, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (512, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (511, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (510, 'TE', 'TESPEC.GDR', '1', '[endif] ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (509, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errmsg} IN OUT VARCHAR2');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (508, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errnum} IN OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (507, 'TE', 'TESPEC.GDR', '1', '[IF][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (506, 'TE', 'TESPEC.GDR', '1', ' {PLG>outRC} OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (505, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (504, 'TE', 'TESPEC.GDR', '1', ' {PLG>inrec} IN ^{PLG>>pkyRT}^,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (503, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>updcolproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (502, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (501, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (500, 'TE', 'TESPEC.GDR', '1', '[endif] ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (499, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errmsg} IN OUT VARCHAR2');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (498, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errnum} IN OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (497, 'TE', 'TESPEC.GDR', '1', '[IF][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (496, 'TE', 'TESPEC.GDR', '1', ' {PLG>outRC} OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (495, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (494, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (493, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (492, 'TE', 'TESPEC.GDR', '1', '[FOREACH]pkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (491, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>updcolproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (490, 'TE', 'TESPEC.GDR', '1', ' --// Update procedure for [colname]. --//');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (489, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (488, 'TE', 'TESPEC.GDR', '1', '[FOREACH]updcol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (487, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (486, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (485, 'TE', 'TESPEC.GDR', '1', ' ); ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (484, 'TE', 'TESPEC.GDR', '1', '[endif]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (483, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errmsg} IN OUT VARCHAR2');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (482, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errnum} IN OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (481, 'TE', 'TESPEC.GDR', '1', '[IF][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (480, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>outRC}^ OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (479, 'TE', 'TESPEC.GDR', '1', ' {PLG>inrec} IN {PLG>>tableRT},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (478, 'TE', 'TESPEC.GDR', '1', ' {PLG>oldinrec} IN {PLG>>tableRT},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (477, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>updpkyproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (476, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (475, 'TE', 'TESPEC.GDR', '1', ' ); ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (474, 'TE', 'TESPEC.GDR', '1', '[endif]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (473, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errmsg} IN OUT VARCHAR2');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (472, 'TE', 'TESPEC.GDR', '1', ' ,{PLG>errnum} IN OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (471, 'TE', 'TESPEC.GDR', '1', '[IF][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (470, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>outRC}^ OUT INTEGER');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (469, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (468, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype} := NULL,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (467, 'TE', 'TESPEC.GDR', '1', '[FOREACH]pkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (466, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (465, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>oldincol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (464, 'TE', 'TESPEC.GDR', '1', '[FOREACH]pkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (463, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>updpkyproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (462, 'TE', 'TESPEC.GDR', '1', ' --// Update Primary Key column(s) procedure. --//');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (461, 'TE', 'TESPEC.GDR', '1', '[IF]updpky');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (460, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (459, 'TE', 'TESPEC.GDR', '1', ' {PLG>inreset} IN BOOLEAN DEFAULT TRUE);');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (458, 'TE', 'TESPEC.GDR', '1', '[endif] ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (457, 'TE', 'TESPEC.GDR', '1', ' {PLG>errmsg} IN OUT VARCHAR2,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (456, 'TE', 'TESPEC.GDR', '1', ' {PLG>errnum} IN OUT INTEGER,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (455, 'TE', 'TESPEC.GDR', '1', '[IF][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (454, 'TE', 'TESPEC.GDR', '1', ' {PLG>outRC} OUT INTEGER,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (453, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>updproc}^ ({PLG>inrec} IN {PLG>>tableRT},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (452, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (451, 'TE', 'TESPEC.GDR', '1', ' --// Record-based Update //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (450, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (449, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (448, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>inreset}^ IN BOOLEAN DEFAULT TRUE');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (447, 'TE', 'TESPEC.GDR', '1', '[endif] ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (446, 'TE', 'TESPEC.GDR', '1', ' {PLG>errmsg} IN OUT VARCHAR2,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (445, 'TE', 'TESPEC.GDR', '1', ' {PLG>errnum} IN OUT INTEGER,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (444, 'TE', 'TESPEC.GDR', '1', '[IF][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (443, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>outRC}^ OUT INTEGER,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (442, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (441, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype} DEFAULT NULL,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (440, 'TE', 'TESPEC.GDR', '1', '[FOREACH]nonpkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (439, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (438, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (437, 'TE', 'TESPEC.GDR', '1', '[FOREACH]pkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (436, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>updproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (435, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (434, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (433, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (432, 'TE', 'TESPEC.GDR', '1', ' PRAGMA RESTRICT_REFERENCES (^{PLG>frccolfunc}^, WNDS, RNDS);');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (431, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (430, 'TE', 'TESPEC.GDR', '1', ' RETURN {PLG>coltype};');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (429, 'TE', 'TESPEC.GDR', '1', ' (^{PLG>incol}^ IN {PLG>coltype} DEFAULT NULL)');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (428, 'TE', 'TESPEC.GDR', '1', ' FUNCTION ^{PLG>frccolfunc}^ ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (427, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (426, 'TE', 'TESPEC.GDR', '1', '[FOREACH]nonpkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (425, 'TE', 'TESPEC.GDR', '1', ' --// Force setting of NULL values //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (424, 'TE', 'TESPEC.GDR', '1', '');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -