📄 te.ins
字号:
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (423, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>resetfrcproc}^;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (422, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (421, 'TE', 'TESPEC.GDR', '1', '--// Update Processing //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (420, 'TE', 'TESPEC.GDR', '1', '[IF]havenonpkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (419, 'TE', 'TESPEC.GDR', '1', '[IFNOT]queryonly');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (418, 'TE', 'TESPEC.GDR', '1', '[ENDIF]checkDI');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (417, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (416, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (415, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (414, 'TE', 'TESPEC.GDR', '1', ' {PLG>record_error} IN BOOLEAN := TRUE ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (413, 'TE', 'TESPEC.GDR', '1', ' {PLG>errmsg} IN OUT VARCHAR2, ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (412, 'TE', 'TESPEC.GDR', '1', ' {PLG>errnum} IN OUT INTEGER,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (411, 'TE', 'TESPEC.GDR', '1', ' {PLG>valuesOK} OUT BOOLEAN,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (410, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE {PLG>valproc} ({PLG>inrec} IN {PLG>>tableRT},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (409, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (408, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (407, 'TE', 'TESPEC.GDR', '1', ' {PLG>record_error} IN BOOLEAN := TRUE ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (406, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>errmsg}^ IN OUT VARCHAR2, ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (405, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>errnum}^ IN OUT INTEGER,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (404, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>valuesOK}^ OUT BOOLEAN,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (403, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (402, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (401, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]uconscol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (400, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>valproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (399, 'TE', 'TESPEC.GDR', '1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (398, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (397, 'TE', 'TESPEC.GDR', '1', ' {PLG>record_error} IN BOOLEAN := TRUE ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (396, 'TE', 'TESPEC.GDR', '1', ' {PLG>inrec} IN {PLG>>tableRT},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (395, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>valproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (394, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (393, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (392, 'TE', 'TESPEC.GDR', '1', ' {PLG>record_error} IN BOOLEAN := TRUE ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (391, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (390, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (389, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]uconscol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (388, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>valproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (387, 'TE', 'TESPEC.GDR', '1', '[IFNOT][retcd]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (386, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (385, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (384, 'TE', 'TESPEC.GDR', '1', ' PRAGMA RESTRICT_REFERENCES (^{PLG>chkfunc}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (383, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (382, 'TE', 'TESPEC.GDR', '1', ' ) RETURN BOOLEAN;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (381, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (380, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (379, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]conscol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (378, 'TE', 'TESPEC.GDR', '1', ' FUNCTION ^{PLG>chkfunc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (377, 'TE', 'TESPEC.GDR', '1', ' --// Check Constraint: [search_condition] //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (376, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (375, 'TE', 'TESPEC.GDR', '1', '[FOREACH]cons');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (374, 'TE', 'TESPEC.GDR', '1', '--// Check Constraint Validation //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (373, 'TE', 'TESPEC.GDR', '1', '[IF][havecons]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (372, 'TE', 'TESPEC.GDR', '1', '[IF]checkDI');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (371, 'TE', 'TESPEC.GDR', '1', '[endif]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (370, 'TE', 'TESPEC.GDR', '1', ' );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (369, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>record_error}^ BOOLEAN := TRUE ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (368, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (367, 'TE', 'TESPEC.GDR', '1', ' [ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (366, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>outfkyparm}^ OUT ^{PLG>fkypackage}^.^{PLG>descindexrt}^,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (365, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (364, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype},');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (363, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]fkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (362, 'TE', 'TESPEC.GDR', '1', ' --// Foreign key columns for {[fkyname]} //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (361, 'TE', 'TESPEC.GDR', '1', ' [IF][tabwithdesc]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (360, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]fky');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (359, 'TE', 'TESPEC.GDR', '1', ' PROCEDURE ^{PLG>lookupfkydescproc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (358, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (357, 'TE', 'TESPEC.GDR', '1', '[IF][havefkydesc]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (356, 'TE', 'TESPEC.GDR', '1', '[ENDIF]usecountrows');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (355, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]fky');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (354, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (353, 'TE', 'TESPEC.GDR', '1', ' PRAGMA RESTRICT_REFERENCES (^{PLG>fkycountfunc}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (352, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (351, 'TE', 'TESPEC.GDR', '1', ' RETURN INTEGER;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (350, 'TE', 'TESPEC.GDR', '1', ' )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (349, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (348, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (347, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]fkycol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (346, 'TE', 'TESPEC.GDR', '1', ' FUNCTION ^{PLG>fkycountfunc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (345, 'TE', 'TESPEC.GDR', '1', '[FOREACH]fky');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (344, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (343, 'TE', 'TESPEC.GDR', '1', ' PRAGMA RESTRICT_REFERENCES (^{PLG>pkycountfunc}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (342, 'TE', 'TESPEC.GDR', '1', ' PRAGMA RESTRICT_REFERENCES (^{PLG>tabcountfunc}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (341, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (340, 'TE', 'TESPEC.GDR', '1', ' RETURN INTEGER;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (339, 'TE', 'TESPEC.GDR', '1', ' )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (338, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (337, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (336, 'TE', 'TESPEC.GDR', '1', ' [FOREACH]pkycol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (335, 'TE', 'TESPEC.GDR', '1', ' FUNCTION ^{PLG>pkycountfunc}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (334, 'TE', 'TESPEC.GDR', '1', ' FUNCTION ^{PLG>tabcountfunc}^ RETURN INTEGER;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (333, 'TE', 'TESPEC.GDR', '1', ' --// Count of all rows in table and for each foreign key. //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (332, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (331, 'TE', 'TESPEC.GDR', '1', '[IF]usecountrows');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (330, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (329, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (328, 'TE', 'TESPEC.GDR', '1', ' PRAGMA RESTRICT_REFERENCES (^{PLG>getupdcol}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (327, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (326, 'TE', 'TESPEC.GDR', '1', ' RETURN ^{PLG>coltype}^;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (325, 'TE', 'TESPEC.GDR', '1', ' )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (324, 'TE', 'TESPEC.GDR', '1', ' [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (323, 'TE', 'TESPEC.GDR', '1', ' ^{PLG>incol}^ IN {PLG>coltype}');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -