Hello again! It’s due time to provide the answers for my second quiz – the one about NULL in aggregate functions.
In this particular quiz, it wasn’t the point to pick the correct choices, but rather figure out what will be the result of running each of the SELECTs. Czytaj dalej
Aww. So dusty in here. Where have I been for the past seven months?!
Either way, it’s that time. Yep, you know what I mean – it’s the QUIZ TIME!
I’ve got a new quiz for you today:
What will be the result of running each of the SELECTs? Czytaj dalej
In my last post, I’ve challenged you with a quiz about package dependency. The question was about when a dependent object will be invalidated by Oracle when the package on which it depends is recreated.
The choices which give the „INVALID” status are:
Czytaj dalej
I’ve got the following quiz for you today:
After running which of the following code snippets will the 'INVALID’ status be returned?
Assumptions:
dummy_pkg and print_message objects do not exist.I’ll provide the answer in my next post.
The choices:
Czytaj dalej
1 > NULL AND cross_the_road()…I bet you have heard about the chicken and you know at least a dozen reasons why it had crossed the road. I wouldn’t bet, though, that you have heard about the three-valued logic. And this one is interesting, it even makes the chicken cross the road. The answer to the above question could also be given as: Because it (the chicken) didn’t short-circuit evaluate. What does it all mean? Czytaj dalej