无论用户插入记录，还是修改EMP表的job列，都将用户指定的job列的值转换成大写。
CREATE OR REPLACE TRIGGER biu_job_emp Before insert or update of job on emp For each row BEGIN
:NEW.job :=upper(;new.job) END;
答案 1．A 2．D 3．C 4．A 5．B 6．B 7．B 8．C 9．B 10．C 11．C 12．C 13．A 14．B 15．D 16．C 17．D 18．B 19．A 20．B 21．C 22．C 23．C 24．A 25．A 26．A 27．A 28．A 29．B 30．C 二、填空题（每空2分，共40分） [1] [2] [3] [4] [5] [6] [7] [8] [9] Connect martin/martinpass@aptech Grant select on scott.emp to martin Select * from employee where 1=2 To_char NVL even_number 1..25 SELECT ename INTO empname FROM employee WHERE empno=eno; EXCEPTION [10] OPEN toy_cur [11] FETCH toy_cur INTO my_toy_price; [12] FOR sales_rec IN sales_cur LOOP [13] sales_rec.tsales = sales_rec.asales
[14] IN OUT [15] SELECT deptno INTO dept_no FROM emp WHERE empno=emp_no; [16] RETURN result; [17] pack_ma.order_proc(‘002’） [18] BEFORE INSERT OR UPDATE OF job ON emp [19] FOR EACH ROW [20] UPPER(:NEW.job)