Apex and database connections
I was asked to install APEX. I'm new to this so I want to know prior to the installation. Can you tell me which one of the two is valid.
Can I have one APEX instance to connect to multiple databases. I create one APEX instance on port 8080 and from there development/runtime can be done on both production and test databases.
OR
In order to develop/run in multiple databases I must create one instance on each database. One APEX instance on port 8080 to make development/runtime on production database and one APEX instance on port 8081 to make development/runtime on test database.