oracle_DML

DML语句：insert、update、delete

insert 增

       插入子查询的结果 insertinto dept2 select * from dept;

       插入整条 insertinto dept2 values(50, 'Test','Beijing');

       插入某些字段 insertinto dept2(deptno, loc) values(60, 'Shenzhen');

update 更新

       update dept2 set dname = 'HR', loc = 'Guangzhou' where deptno = 60;

delete 删除

       delete from dept2 where rownum <= 4;

       delete from dept2 where deptno = 50 ordeptno = 60;