📄 temp_cts5tab.out
字号:
1 row inserted/updated/deletedij> INSERT INTO A VALUES (11, 7);1 row inserted/updated/deletedij> INSERT INTO A VALUES (17, 3);1 row inserted/updated/deletedij> INSERT INTO A VALUES (15, 1);1 row inserted/updated/deletedij> INSERT INTO A VALUES (13, 5);1 row inserted/updated/deletedij> INSERT INTO A VALUES (13, 15);1 row inserted/updated/deletedij> INSERT INTO A VALUES (11, 1);1 row inserted/updated/deletedij> INSERT INTO A VALUES (5, 5);1 row inserted/updated/deletedij> INSERT INTO A VALUES (5, 3);1 row inserted/updated/deletedij> INSERT INTO A VALUES (1, 1);1 row inserted/updated/deletedij> DELETE FROM TT;0 rows inserted/updated/deletedij> INSERT INTO TT (TTA, TTC) VALUES (1, 99);1 row inserted/updated/deletedij> INSERT INTO TT (TTA, TTB) VALUES (2, 98);1 row inserted/updated/deletedij> INSERT INTO TT VALUES (3, 97, 96);1 row inserted/updated/deletedij> INSERT INTO TT (TTA) VALUES (4);1 row inserted/updated/deletedij> INSERT INTO TT VALUES (5, 42, 26);1 row inserted/updated/deletedij> DELETE FROM TU;0 rows inserted/updated/deletedij> INSERT INTO TU VALUES ('ab', 3);1 row inserted/updated/deletedij> INSERT INTO TU (TUE) VALUES (5);1 row inserted/updated/deletedij> INSERT INTO TU VALUES ('cd', 4);1 row inserted/updated/deletedij> INSERT INTO TU (TUE) VALUES (11);1 row inserted/updated/deletedij> INSERT INTO TU VALUES ('ef', 12);1 row inserted/updated/deletedij> INSERT INTO TU VALUES ('gh', 11);1 row inserted/updated/deletedij> --O DELETE FROM TT2;--O INSERT INTO TT2 VALUES (1,INTERVAL '17-3' YEAR TO MONTH,13);--O--O INSERT INTO TT2 (TTA,TTB) VALUES (2,INTERVAL '5-6' YEAR TO MONTH);--O--O INSERT INTO TT2 (TTA) VALUES (3);--O--O INSERT INTO TT2 (TTA,TTC) VALUES (4,20);--O--O INSERT INTO TT2 VALUES (5,INTERVAL '60-2' YEAR TO MONTH,19);--O DELETE FROM TV;0 rows inserted/updated/deletedij> INSERT INTO TV VALUES (1,'a');1 row inserted/updated/deletedij> INSERT INTO TV VALUES (2,'b');1 row inserted/updated/deletedij> INSERT INTO TV VALUES (3,'c');1 row inserted/updated/deletedij> INSERT INTO TV VALUES (4,'d');1 row inserted/updated/deletedij> INSERT INTO TV VALUES (5,'e');1 row inserted/updated/deletedij> DELETE FROM TW;0 rows inserted/updated/deletedij> INSERT INTO TW VALUES ('b',2);1 row inserted/updated/deletedij> INSERT INTO TW VALUES ('g',1);1 row inserted/updated/deletedij> INSERT INTO TW VALUES ('f',2);1 row inserted/updated/deletedij> INSERT INTO TW VALUES ('h',4);1 row inserted/updated/deletedij> INSERT INTO TW VALUES ('i',5);1 row inserted/updated/deletedij> DELETE FROM TX;0 rows inserted/updated/deletedij> INSERT INTO TX (TX1, TX3) VALUES (1, 'Susan');1 row inserted/updated/deletedij> INSERT INTO TX (TX1, TX2) VALUES (2, 'lemon');1 row inserted/updated/deletedij> INSERT INTO TX VALUES (3, 'apple', '');1 row inserted/updated/deletedij> INSERT INTO TX VALUES (4, 'melon', 'Peter');1 row inserted/updated/deletedij> INSERT INTO TX VALUES (5, 'peach', 'Matthew');1 row inserted/updated/deletedij> DELETE FROM TEST12849B;0 rows inserted/updated/deletedij> INSERT INTO TEST12849B VALUES (1);1 row inserted/updated/deletedij> INSERT INTO TEST12849B VALUES (2);1 row inserted/updated/deletedij> INSERT INTO TEST12849B VALUES (3);1 row inserted/updated/deletedij> INSERT INTO TEST12849B VALUES (4);1 row inserted/updated/deletedij> DELETE FROM TABX760;0 rows inserted/updated/deletedij> INSERT INTO TABX760 VALUES (10,'SPYROS',25000);1 row inserted/updated/deletedij> INSERT INTO TABX760 VALUES (11,'ALEXIS',18000);1 row inserted/updated/deletedij> INSERT INTO TABX760 VALUES (12,'LAMBIS',9000);1 row inserted/updated/deletedij> INSERT INTO TABX760 VALUES (13,'ELENI',4000);1 row inserted/updated/deletedij> INSERT INTO TABX760 VALUES (14,'MARIOS',47000);1 row inserted/updated/deletedij> INSERT INTO TABX760 VALUES (15,'NICKOLAS',78000);1 row inserted/updated/deletedij> --O DELETE FROM TABCS;--O--O INSERT INTO CTS1.TABCS VALUES (1, _CS 'NICKOS', _CS 'MARIA');--O--O INSERT INTO CTS1.TABCS VALUES (2, _CS 'BILL', _CS 'TAKIS');--O--O INSERT INTO CTS1.TABCS VALUES (3, _CS 'NICKOS', _CS 'TAKIS');--O--O INSERT INTO CTS1.TABCS VALUES (4, _CS 'MARIA', _CS 'TAKIS');--O--O DELETE FROM TTIME3;--O--O INSERT INTO CTS1.TTIME3 VALUES (--O 1,TIME( '23:05:00'),TIME( '12:15:00-11:45'),--O TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:05'));--O--O INSERT INTO CTS1.TTIME3 VALUES(--O 2,TIME( '05:10:00'),TIME( '00:07:00+08:39'), --O TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:05'));--O--O INSERT INTO CTS1.TTIME3 VALUES (--O 3,TIME( '12:11:00'),TIME( '23:19:00+10:32'), --O TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:16'));--O--O INSERT INTO CTS1.TTIME3 VALUES (--O 4,TIME( '05:10:00'),TIME( '00:07:00+08:39'), --O TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:05'));--O--O INSERT INTO CTS1.TTIME3 VALUES (--O 5,TIME( '17:39:00'),TIME( '08:28:00-11:45'), --O TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:05'));--O--O INSERT INTO CTS1.TTIME3 VALUES (--O 6,TIME( '17:39:00'),TIME( '08:28:00-11:45'), --O TIMESTAMP( 'xxxxxxFILTERED-TIMESTAMPxxxxx:05')); DELETE FROM CL_STANDARD;0 rows inserted/updated/deletedij> INSERT INTO CL_STANDARD VALUES (1000,'NICKOS',4000,'ATHENS');1 row inserted/updated/deletedij> INSERT INTO CL_STANDARD VALUES (1001,'MARIA',4001,'RHODES');1 row inserted/updated/deletedij> INSERT INTO CL_STANDARD VALUES (1002,'MAKIS',4002,'HANIA');1 row inserted/updated/deletedij> INSERT INTO CL_STANDARD VALUES (1003,'GEORGE',4003,'ARTA');1 row inserted/updated/deletedij> INSERT INTO CL_STANDARD VALUES (1004,'MORRIS',4004,'PARGA');1 row inserted/updated/deletedij> DELETE FROM TABLE728a;0 rows inserted/updated/deletedij> INSERT INTO TABLE728a VALUES ('NICKOS','GEORGE');1 row inserted/updated/deletedij> INSERT INTO TABLE728a VALUES ('HARRY','TANIA');1 row inserted/updated/deletedij> INSERT INTO TABLE728a VALUES ('KILLER',NULL);1 row inserted/updated/deletedij> INSERT INTO TABLE728a VALUES (NULL,NULL);1 row inserted/updated/deletedij> --O DELETE FROM TAB734;--O--O INSERT INTO CTS1.TAB734 VALUES (N' !',N'* *');--O--O INSERT INTO CTS1.TAB734 VALUES (N' * ',N'+ +');--O--O INSERT INTO CTS1.TAB734 VALUES (N'+ +',N'+ +');--O--O INSERT INTO CTS1.TAB734 VALUES (NULL,N' + ');--O DELETE FROM CL_DATA_TYPE;0 rows inserted/updated/deletedij> INSERT INTO CL_DATA_TYPE VALUES ('GEORGE',1,10,100);1 row inserted/updated/deletedij> INSERT INTO CL_DATA_TYPE VALUES ('NICK',2,20,200);1 row inserted/updated/deletedij> INSERT INTO CL_DATA_TYPE VALUES ('PAUL',3,30,300);1 row inserted/updated/deletedij> INSERT INTO CL_DATA_TYPE VALUES ('PETER',4,40,400);1 row inserted/updated/deletedij> INSERT INTO CL_DATA_TYPE VALUES ('KEVIN',5,50,500);1 row inserted/updated/deletedij> INSERT INTO CL_DATA_TYPE VALUES ('JASON',6,60,600);1 row inserted/updated/deletedij> COMMIT WORK;ij> --O-- *************************************************////END-OF-MODULE;ij>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -