1.一个简单的游标
create or replace procedure proc_emp(emp_no number) AS
v_no scott.emp.empno%type;
v_name scott.emp.ename%type;
v_sal scott.emp.sal%type;
cursor c_s(emp_no2 number) is select a.empno,a.ename,a.sal from scott.emp a where a.empno=emp_no2;
begin
open c_s(emp_no);
loop
fetch c_s into v_no,v_name,v_sal;
exit when c_s%notfound;
dbms_output.put_line('找到员工号对应的员工: '||v_no||' name: '||v_name||' sal: '||v_sal);
end loop;
close c_s;
end;
2.执行
exec proc_emp(7788);
要是不显示输出结果,请执行
set serveroutput on;
3.对于忘记密码来说
alter user scott identified by tiger ;
只能修改。