SQL DML语句练习

--DML 数据操纵语言

--插入数据
INSERT INTO new_emp (empno, ename, job, deptno) values (8800, 'Jack', 'SALESMAN', 30);
--插入数据（不显示写出列值，默认全部插入）
INSERT INTO new_emp values (8888, 'Edward', 'Tang', 7839, TO_DATE('2017-08-04', 'YYYY-MM-DD'), 4000, 200, 10);

--更新数据
UPDATE new_emp SET ename = 'KINGKING'
WHERE empno = 7839;

--删除数据
DELETE FROM new_emp
WHERE empno = 8888;

--同步数据
MERGE INTO new_emp2 e2
USING new_emp e1
ON  (e2.empno = e1.empno)
WHEN MATCHED THEN
     UPDATE SET e2.ename = e1.ename
WHEN NOT MATCHED THEN
     INSERT 
     VALUES (e1.empno, e1.ename, e1.job, e1.mgr, e1.hiredate, e1.sal, e1.comm, e1.deptno);