Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics

Most of us use data dictionary views on an everyday basis to find things like: In which schema does a table with a certain name exist? What tables use a certain column name? Get the line of code from any and all packages where a string named “EMPLOYEE_NUMBER” is used What privileges does a role … Continue reading Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics