update

update emp set sal=2460 where lower(ename)='scott';

select * from emp;

update emp set sal=sal*1.1, comm=sal*0.1
where deptno=20;

select * from emp where empno=7788;

select job from emp where ename='SCOTT';

update emp set job=default where ename='SCOTT'; --如果不存在默认值，会输出null

update emp set hiredate=to_date('1999/03/25','yyyy/mm/dd') where empno=7788;

--使用子查询更新数据--

update emp set
(job,sal,comm)=(select job,sal,comm from emp where ename='SMITH')
where ename='SCOTT';

select * from emp where  lower(ename） in ('scott','smith');

--复制表数据
update employees set department_id=
(select deptno from emp where empno=7788)
where job_ID =(select job from emp where empno=7788);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30090120/viewspace-1422780/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30090120/viewspace-1422780/