【文件属性】:
文件名称:oracle 基础,数据库优化
文件大小:8.41MB
文件格式:RAR
更新时间:2014-01-30 07:43:11
oracle资料
/*departments.location_id//部门地址编号*/
/*复制表的命令
create table emp2 as select * from emp where 1=1;*/
/*一、修改职员表中编号为120号职工的工资加1000并显示此职工的工资,名字 ,入职日期*/
declare
type dd_rec is record(
dd_sal number(8,2),
dd_name varchar2(20),
dd_hiredate date
);
v_rec dd_rec;
begin
update employees2 set salary=employees2.salary+100 where employees2.employee_id=120
returning salary,first_name,hire_date
into v_rec;
dbms_output.put_line(v_rec.dd_sal||v_rec.dd_name||to_char(v_rec.dd_hiredate,'yyyymmdd'));
end;