ORACLE数据库SQL语句基础知识总结二：数据操作语言（DML）

数据操作语言（DML）包括INSERT、UPDATE、DELETE等增删改命令

数据插入
INSERT INTO student_0 (id,sname) VALUES (1,'青衫码客');

结果集插入
INSERT INTO student_2(id,sname) SELECT id,sname FROM student_0;

更新数据
UPDATE student_0 SET id=2,sname='青衫码君' WHERE id=1;

MERGE INTO student_3
USING student_0
ON (student_3.id=student_0.id)
WHEN MATCH THEN UPDATE SET student_3.sname=student_0.sname
WHEN NOT MATCH THEN INSTER (student_3.id,student_3.sname)VALUES(student_0.id,student_0.sname);

删除数据
DELETE FROM student_3 WHERE id=2;