Packages and Dependent Objects

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 →

Packages and Dependent Objects

I’ve got the following quiz for you today:

After running which of the following code snippets will the 'INVALID’ status be returned?

Assumptions:

• Version of Oracle: 11g R2.
• Before each snippet is run, both dummy_pkg and print_message objects do not exist.

I’ll provide the answer in my next post.

The choices:
Czytaj dalej →