Oracle Magazine, July/August 2017
Database Developer PL SQL Youd think TM would congratulate NC on getting that procedure built so quickly but no all NC ever hears is complaints TM doesnt like NC much and the feeling is mutual NC feels like TM is constantly giving her unjustifiably poor performance reviews A month or two goes by The show_ todos procedure is used by everyone constantly NC decides to take action She modifies the show_ todos procedure as follows changes in bold ORACLE MAGAZINE JULY AUGUST 2017 82 CREATE OR REPLACE PROCEDURE show_ todos AUTHID CURRENT_ USER IS BEGIN FOR rec IN SELECT title FROM todo ORDER BY title LOOP DBMS_ OUTPUT put_ line rec title END LOOP IF SYS_ CONTEXT userenv current_ user THE_ BOSS THEN EXECUTE IMMEDIATE begin update performance_ reviews set star_ rating 100
You must have JavaScript enabled to view digital editions.