最新的Oracle Database 11g: Program with PL/SQL (1Z1-144日本語版) - 1Z1-144日本語免費考試真題
CREATE OR REPLACE TRIGGER check_price__trg BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price ON product FOR EACH ROW WHEN (nev.prod_id <> NVX(old.prod_id,0) OR New.prod__list_price <> NVL(old.prod_list_price, 0) ) BEGIN check_price (: new.prod_id) ; END /
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
正確答案: B
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
正確答案: A
正確答案: A
正確答案: B
正確答案: A
SQL> DROP PACKAGE manage_emp;
正確答案: B
正確答案: B