你好，可以简单说下哪一步你不会，或者有疑问的？

具体是建表语句，还是存储过程

简单来说，我会建表并插入语句，之后涨工资不懂，上课时没有听明白，就是存储过程这方面的问题，您能演示一下吗

简单手写了下，没建表。可能要调试

--存储需要调用，不能直接接收输入，采用匿名代码块方式
set serveroutput on;
ACCEPT OID NUMBER PROMPT '请输入医生ID : ';
ACCEPT OP varchar(20) PROMPT '请输入操作 : ';

DECLARE
v_oid number := &v_oid;
v_op varchar := &v_op;
v_sal doctor.sal%type;
BEGIN
IF( v_op = 1 ) THEN 
	SELECT sal INTO v_sal FROM doctor WHERE id = v_oid;
  if (v_sal < 3000) then
  	update doctor set sal = sal*1.25 where id = v_oid;
  else if (v_sal >= 3000 && v_sal < 5000) then 
  	update doctor set sal = sal*1.15 where id = v_oid;
  else if (v_sal >= 5000)	then
  	update doctor set sal = sal*1.05 where id = v_oid;	
  dbms_output.put_line('a is less than 20 ' ); 
  end if;
ELSE IF ( v_op = 2 ) THEN 
	delete from doctor where id = v_oid;
END IF; 
END; 
/

--触发器记录日志
create or replace trigger tri_log_doctor_sal
after update of sal on doctor
for each row  
begin
insert into log_doctor_sal (id,oldsal,newsal) values (:old.id,:old.sal,:new.sal);
end;
复制