In context of this article (and applied trigger) the query will NOT work.
Ah. Good point. Subhash's question could have been meant in one of two ways: 1) Will this query work generally (yes, affecting all rows), or 2) Will this query work if I have Rahul's trigger installed (no, it will give the error message raised by the trigger and roll back).
In context of answering general questions about such a basic SQL queries like this - this is wrong thread and/or wrong forum to ask such a question
Yes, I guess it is. And nicely put, too.
...and also to answer it.
Ah well - that's nice for Subhash - between us we've answered it for him, whichever way he meant it.
Jinlye