本科大型数据库技术测试题.pptxVIP

Oracle测试题;B;B;C;;药品库存表kc create table kc( id number(2) primary key, --药品id ypname varchar2(20),--药品名称 num number(5) --数量 ); insert into kc values (1,青霉素,3000); insert into kc values (2,双黄连,4000);;create or replace procedure deliver(v_name VARCHAR2, v_num NUMBER) as v_kc NUMBER; v_left NUMBER; v_p_id NUMBER; cursor cur_batchkc(v_id NUMBER) is select bnum from batchkc where id=v_id order by validdate for update; begin select num, id into v_kc, v_p_id from kc where ypname=v_name; if v_kc = v_num then v_left := v_num; for iter in cur_batchkc(v_p_id) loop if ite