December 2023 archive

Dec 05

How to check the code of the most important Oracle internal objects without having a database

Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA. Let's say, for example, that I need to get the view SQL code for DBA_USERS we had …

Continue reading