I can compile a procedure successfully even tho it contains two declarations with the same name for the identifier. Can you?
But Twitter is probably not the best way to do this, since it is not easy to capture every nuance in a tweet.
For example, Jonathan Whitehead asked: "Complier directives?"
Which leads me to "tweak" the brain teaser to fully elaborate as follows:
The Brain Teaser
I can compile a procedure successfully even though it contains two declarations with the same name for the identifier. And after compilation, if I run DBMS_PREPROCESSOR.print_post_processed_source to display the actual source code that was compiled into the database, it will show BOTH of those declarations.
OK....now, clever PL/SQL developers, can you post an example of code that will solve this teaser?