3,490
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE test(id NUMBER(5),sname VARCHAR2(30));
INSERT INTO test VALUES (1,'test1');
INSERT INTO test VALUES (2,'test2');
INSERT INTO test VALUES (3,'test3');
INSERT INTO test VALUES (4,'test4');
INSERT INTO test VALUES (5,'test5');
SELECT * FROM test;
ID SNAME
1 test1
2 test2
3 test3
4 test4
5 test5
UPDATE test SET sname='test6' WHERE id=3;
SELECT * FROM test;
ID SNAME
1 test1
2 test2
3 test6
4 test4
5 test5
DELETE FROM test WHERE sname='test6';
SELECT * FROM test;
ID SNAME
1 test1
2 test2
4 test4
5 test5
INSERT INTO test VALUES (3,'test3');
SELECT * FROM test;
ID SNAME
1 test1
2 test2
4 test4
5 test5
3 test3