My quiz on the PL/SQL Challenge

On friday my quiz was on the PL/SQL Challenge.

Topic: “Guidelines for Designing Triggers: Avoid Non-Transactional Logic in DML Triggers”

Yes, about “statement restart” 🙂
My idea about the quiz was “making developers aware of the Oracle behaviour”.
And I hope a lot of PL/SQL developers learned from it.

It wasn’t easy to come up with the question, the way of asking, the correct words, the answers…
But after a lot of mailing between Steven and the reviewers we finally had a quiz.

A lot people had it wrong, but I hope they don’t mind and are now aware of statement restart.

For more information and discussion about the quiz: PL/SQL Challenge blog


3 thoughts on “My quiz on the PL/SQL Challenge

  1. Hi Poelger,

    Thank you for the effort you put into this question. It was simple and well worded – the hallmarks of a great PL/SQL Challenge question.

    I got this question wrong, so I was reminded of something that I should have known from past experience 🙂

    Well done!

  2. Thanks!

    Indeed, it’s nice when you have 100% on a question, but it’s more interesting when you learn something and I think a lot of people didn’t know this behaviour(now they do!).

    Tom Kyte in his blogpost(
    “Why they were restarted – not really relevant – the fact is – they CAN be restarted, we can show that they can be restarted, it is documented that they can be.”

    But I’m also a bit curious why it happens.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

About Gert Poel