20 July 2010
19 July 2010 quiz: some concerns raised by players(1233)
The 19 July quiz addressed the question of how to disable a trigger on a table. Here are the two comments I have received: "While I know that the answers are correct for the July 19th, 2010 quiz, I think the answer is a bit misleading. You can disable triggers with the ALTER TABLE command , you can't specify a specific trigger, but you can say 'ALTER TABLE disable all triggers' " "It is not clear if today quiz is well formulated - while ALTER TRIGGER sometrigger DISABLE / is obviously valid it is not PL/SQL, rather plain SQL." Addressing the second point, yes, certainly this is not PL/SQL per se. It is, however, a common task for developers, in my experience, and therefore worthy of testing on the PL/SQL Challenge. What are your thoughts?