Deploying an application with SQL Developer
In most situations, an application is developed in a development environment on a development database. When the application is ready, it is deployed to the test environment so that it can be tested. Finally, when the test results are fine, the application is deployed to the production environment. To deploy an application, you can use Oracle SQL Developer.
Getting ready
You need to have Oracle SQL Developer installed on your computer. Preferably the latest version. You can download Oracle SQL Developer via http://otn.oracle.com.
Also, you need to have two different environments to deploy the application from one environment to another.
Furthermore, you need to have an application that is ready to be deployed.
And last, make sure that you have a connection in SQL Developer using the right database user. If you use the embedded PL/SQL gateway, use ANONYMOUS
, otherwise use APEX_PUBLIC_USER
.
How to do it...
Perform the following steps:
Open Oracle SQL Developer...