📄 temp_cts5tab.out
字号:
ij> AUTOCOMMIT OFF;ij> --O-- MODULE CTS5TAB --O--O-- NIST SQL Test Suite, V6.0, Interactive SQL, cts5tab.sql--O-- 59-byte ID--O-- TEd Version #--O--O-- AUTHORIZATION CTS1 CREATE SCHEMA CTS1;ERROR X0Y68: Schema 'CTS1' already exists.ij> set schema CTS1;0 rows inserted/updated/deletedij> --O--O SELECT USER FROM HU.ECCO; VALUES USER;1 --------------------------------------------------------------------------------------------------------------------------------CTS1 ij> --O-- RERUN if USER value does not match preceding AUTHORIZATION comment--O--O-- date_time print--O--O ROLLBACK WORK;--O DELETE FROM CTS1.ECCO;0 rows inserted/updated/deletedij> INSERT INTO CTS1.ECCO VALUES ('NL');1 row inserted/updated/deletedij> DELETE FROM STAFF;0 rows inserted/updated/deletedij> INSERT INTO STAFF VALUES ('E1','Alice',12,'Deale');1 row inserted/updated/deletedij> INSERT INTO STAFF VALUES ('E2','Betty',10,'Vienna');1 row inserted/updated/deletedij> INSERT INTO STAFF VALUES ('E3','Carmen',13,'Vienna');1 row inserted/updated/deletedij> INSERT INTO STAFF VALUES ('E4','Don',12,'Deale');1 row inserted/updated/deletedij> INSERT INTO STAFF VALUES ('E5','Ed',13,'Akron');1 row inserted/updated/deletedij> DELETE FROM WORKS;0 rows inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E1','P1',40);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E1','P2',20);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E1','P3',80);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E1','P4',20);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E1','P5',12);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E1','P6',12);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E2','P1',40);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E2','P2',80);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E3','P2',20);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E4','P2',20);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E4','P4',40);1 row inserted/updated/deletedij> INSERT INTO WORKS VALUES ('E4','P5',80);1 row inserted/updated/deletedij> DELETE FROM VTABLE;0 rows inserted/updated/deletedij> INSERT INTO VTABLE VALUES(10,+20,30,40,10.50);1 row inserted/updated/deletedij> INSERT INTO VTABLE VALUES(0,1,2,3,4.25);1 row inserted/updated/deletedij> INSERT INTO VTABLE VALUES(100,200,300,400,500.01);1 row inserted/updated/deletedij> INSERT INTO VTABLE VALUES(1000,-2000,3000,NULL,4000.00);1 row inserted/updated/deletedij> DELETE FROM CTS1.STAFFb;0 rows inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (10000,'Fred',40,'P2','Vienna','M');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (10000,'Fred',40,'P2','Vienna','M');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (10000,'Fred',40,'P2','Vienna','M');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (15000,'Carmen',35,'P2','Vienna','F');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (15000,'Carmen',35,'P2','Vienna','F');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (10000,'Alice',40,'P3','Prague','F');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (20000,'Betty',30,'P1','Deale','F');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (20000,'Betty',30,'P1','Deale','F');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (40000,'Don',70,'P3','Prague','M');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (40000,'Don',70,'P3','Prague','M');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (40000,'Don',70,'P3','Prague','M');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFb VALUES (10000,'Ed',40,'P1','Deale','M');1 row inserted/updated/deletedij> DELETE FROM CTS1.STAFFa;0 rows inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (40,10000,'E6',2,'Fred');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (40,10000,'E6',2,'Fred');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (40,10000,'E1',3,'Alice');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (40,10000,'E1',3,'Alice');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (70,40000,'E4',3,'Don');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (70,40000,'E4',3,'Don');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (70,40000,'E4',3,'Don');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (30,20000,'E2',1,'Betty');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (60,45000,'E7',4,'Grace');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (60,45000,'E7',4,'Grace');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (30,8000,'E8',2,'Henry');1 row inserted/updated/deletedij> INSERT INTO CTS1.STAFFa VALUES (15,7000,'E9',1,'Imogen');1 row inserted/updated/deletedij> DELETE FROM STAFFc;0 rows inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E1','Alice',12,'Deale',NULL);1 row inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E2','Betty',10,'Vienna','E1');1 row inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E3','Carmen',13,'Vienna','E2');1 row inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E4','Don',12,'Deale','E2');1 row inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E5','Don',12,'Deale','E1');1 row inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E6','Tom',14,'Gettysburg','E5');1 row inserted/updated/deletedij> INSERT INTO STAFFc VALUES ('E7','Kingdom',18,'Gettysburg','E7');1 row inserted/updated/deletedij> DELETE FROM STAFF_CTS2;0 rows inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E1','Alice',12,'Deale');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E1','Alice',12,'Deale');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E2','Betty',10,'Vienna');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E3','Carmen',13,'Vienna');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E3','Carmen',13,'Vienna');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E3','Carmen',13,'Vienna');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E4','Don',12,'Deale');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS2 VALUES ('E6','Don',12,'Deale');1 row inserted/updated/deletedij> DELETE FROM STAFF_CTS;0 rows inserted/updated/deletedij> INSERT INTO STAFF_CTS VALUES ('P1','Deale',12,'Don');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS VALUES ('P3','Vienna',10,'Betty');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS VALUES ('P3','Vienna',10,'Betty');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS VALUES ('P4','Vienna',13,'Carmen');1 row inserted/updated/deletedij> INSERT INTO STAFF_CTS VALUES ('P5','Prague',15,'Ed');1 row inserted/updated/deletedij> DELETE FROM EMPLOYEES2;0 rows inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Atherton',1);1 row inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Botham',2);1 row inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Cowdrey',3);1 row inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Dev',4);1 row inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Edmunds',5);1 row inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Fields',6);1 row inserted/updated/deletedij> INSERT INTO EMPLOYEES2 VALUES ('Gower',7);1 row inserted/updated/deletedij> DELETE FROM A;0 rows inserted/updated/deletedij> INSERT INTO A VALUES (1, 15);1 row inserted/updated/deletedij> INSERT INTO A VALUES (3, 17);1 row inserted/updated/deletedij> INSERT INTO A VALUES (7, 11);1 row inserted/updated/deletedij> INSERT INTO A VALUES (5, 9);1 row inserted/updated/deletedij> INSERT INTO A VALUES (13, 13);1 row inserted/updated/deletedij> INSERT INTO A VALUES (9, 5);⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -