DML "data manipulation language" 数据操纵语言
insert , update, delete ,merge 增,改, 删
insert 语法:
insert into table (column, column,,,,,,) values(value, value,,,,,,)
例:
insert into dept (deptno,dname) values (60,'mis');
insert into dept values(70,'finace',null);
update 语法:
update table set column=value,volumn=value.....where condition
例:
update emp set deptno=20 where empno=7782;
update emp set (job, deptno) =(select job,deptno from emp where empno=7499)
where empno=7698;
关联子查询更新
create table emp1 as select empno,ename,deptno from emp;
alter table emp1 add (loc varchar2(10));
update emp1 e
set loc=(select loc from dept d where d.deptno=e.deptno);
delete 语法: 删除表中的行
delete from table
where .....condition
如果 where 后面不加条件,删除整张表的数据,,,