Create Oracle Database Cloud connection in SQL Developer

One of the most basic things to start working on Database Cloud Service offered by Oracle (PAAS) is to create a connection to Database Cloud service from local SQL Developer and browse through the schema and database objects.

The most important and foremost step for using cloud service is to have all the information of the cloud service instance.

Once you logon to the service dashboard by logging into cloud.oracle.com you can see all the services allocated to your account in the dashboard.

Now in order to get the information about database service, click on the database service icon.

After the click , you will be taken to the database service console with its information.

The service instance url is the complete url which is required to create the connection from SQL Developer.

Now open the SQL Developer and create a new connection in cloud connections.

Now enter the credentials and complete url into the url field.

Click on OK and one can see the connection created in Connections window and click it to expand the connection.

On clicking of the table, one can see its schema on the right as well as the data in the table.

Thanks !!