Connecting SQL Developer Web to Autonomous Database Cloud

In the previous article(Click here), we seen how to provision Autonomous Database Cloud Service in Oracle Cloud Infrastructure Services.

Let's now see how we can access that Autonomous Transaction Processing Database Cloud Service using the SQL Developer Web console and start playing with that with minimal command line skills. You can do most out of this web tool graphically.



Login to your Oracle Cloud tenant and go to the "Autonomous Transaction Processing" > click on it.

Autonomous Databases page opens where you would get the list of all ATP instances you have provisioned, now click on the Name of the Autonomous Database you want. In my case, only one ATP instance is there so I click on it.

Now Autonomous Database Details page opens, here you see detailed information of the ATP instance, Now click on the "Service Console" to go to the "Overview" monitoring page for this database.

Here on this page, click on the "Development" menu at left side and the click on "SQL Developer Web".

Oracle SQL Developer Web page opens now, here you provide the default ADMIN user and its password that you have provided while provisioning the Autonomous Database and click on "Sign in".

Once you connect, SQL Developer Worksheet opens, now here you can play with your development stunts and even do "Data Modeling" using the "Data Modeler" tab.

To view the execution plan for a particular SQL statement, just select the SQL statement of interest in the worksheet and then click on the Execution Plan icon on the worksheet menu just at the top.

Graphically, even you can create index for a table here.

Once you apply the index property for the table, you get the output result with its DDLs.

Once you select "All objects" in the navigation panel, you get all objects list, in our case newly created index is visible now.

Index getting used for our select statement now.

Hope it helps, subscribe to this blog to stay updated on latest Oracle Autonomous Database features and new articles.

Twitter : https://twitter.com/rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219