Change APEX admin password if the account is locked.
Instead of manually compiling procedures, functions, packages and triggers, it’s possible to compile the entire schema by using Oracle’s built in utility.
Sometimes we need to get the DDL of a database object using sqlplus. There are a few things to have in mind.
Useful to determine the database version and if you have APEX (Application Express) and/or Java Virtual Machine (JVM) installed.
Series of actions to determine database state