emp表
empno ename job sal deptno
7369 SMITH CLERK 1500 20
7499 ALLEN SALESMAN 1800 30
7521 WARD SALESMAN 2000 30
7566 JONES MANAGER 2300 20
7654 MARTIN SALESMAN 1900 30
7698 BLAKE MANAGER 1789 30
7782 CLARK MANAGER 3200 10
7788 SCOTT ANALYST 2300 20
7839 KING PRESIDENT 890 10
7876 ADAMS CLERK 1300 30
7900 JAMES CLERK 2300 20
7902 FORD ANALYST 2200 10
7934 MILLER CLERK 3100 10
功能:对10部门的工资加100,20部门的工资加200,30部门的加300
本人知道容易,但平时写得少,呵呵,谢谢.
empno ename job sal deptno
7369 SMITH CLERK 1500 20
7499 ALLEN SALESMAN 1800 30
7521 WARD SALESMAN 2000 30
7566 JONES MANAGER 2300 20
7654 MARTIN SALESMAN 1900 30
7698 BLAKE MANAGER 1789 30
7782 CLARK MANAGER 3200 10
7788 SCOTT ANALYST 2300 20
7839 KING PRESIDENT 890 10
7876 ADAMS CLERK 1300 30
7900 JAMES CLERK 2300 20
7902 FORD ANALYST 2200 10
7934 MILLER CLERK 3100 10
功能:对10部门的工资加100,20部门的工资加200,30部门的加300
本人知道容易,但平时写得少,呵呵,谢谢.
解决方案 »
- 求解释: select .......... where 1=0
- 求sql语句,求id为偶数的数据。
- oracle中的绘图功能
- 升级散分,祝大家元旦快乐啊
- 做开发10年第一次遇见“遍历游标时”时出错。看后受益非浅
- 关于触发器的问题。请高手们一定帮忙,在线等....
- oracle9i的安装?
- DEVELOP如何访问LINUX上的ORACLE trnsname.ora里每个字段什么意思
- 数据库导出错误:ORA-3127,请高手帮忙~
- 大力兄:在.NET里面,用 mydata.Fill(ds); 得到Oracle的存储过程的记录集,抛出一个异常,请帮我看看怎么解决?(
- Oracle Application Framework中,做下拉框的LIST时,写的SQL绑到LIST上和真实查询的结果不一样
- 运行出问题了,麻烦看看,出在哪?
update emp set sal = (case deptno when 10 then sal+100 when 20 then sal+200 when 30 then sal+300 else sal end);
BEGIN
update emp set sal = (case deptno when 10 then sal+100 when 20 then sal+200 when 30 then sal+300 else sal end);
end;
..........
End;Exception When others then Rollback;End;
as
deptno number;
sal number;
Beginupdate emp set sal = (case deptno when 10 then sal+100 when 20 then sal+200 when 30 then sal+300 else sal end);
End upemp;
DEPTNO NUMBER;
SAL NUMBER;
BEGIN
UPDATE EMP
SET SAL = DECODE(DEPTNO, 10, SAL + 100, 20, SAL + 200, 30, SAL + 300);
END UPEMP;
BEGIN
update emp set sal = (case deptno when 10 then sal+100 when 20 then sal+200 when 30 then sal+300 else sal end);
end;
cursor emp_cursor(no number) is
select ename from emp where deptno=no;
v_ename emp.ename%type;
BEGIN
open emp_cursor(10);
loop
fetch emp_cursor into v_ename;
exit when emp_cursor%notfound;
dbms_output.put_line('雇员名:'||v_ename);
end loop;
close emp_cursor;
end;