Standard service - a fixed amount of work that is performed at a fixed price.  Post Service


Monday, 24 June 2019 02:13

SQL Developer Web now available for Oracle Autonomous Database

Written by
Rate this item
(0 votes)

The Autonomous Database is offered via two services in our Oracle Cloud, Autonomous Data Warehouse and Autonomous Transaction Processing.

Both use machine learning and automation to eliminate
complexity, human
error, and manual management, helping to ensure higher reliability, security, and more
operational efficiency.

Available as of today, these services now also includes:

  • Oracle SQL Developer Web
  • Oracle REST Data Services for RESTful Services and SODA

From your Autonomous Database Service Console, you can launch SQL Developer Web for managing and working your Oracle Database. Run queries, create tables, generate schema diagrams, and much more.

SQL Developer is a mature desktop offering servicing more than 5,000,000 Oracle professionals around the world, and now it’s primary features are also available directly in your browser.

An Overview of SQL Developer Web

3 short videos demonstrating the major features

Accessing SQL Developer Web

Navigate to your Autonomous Database Service Console. Then, open the Administration page, and you’re find the REST Data Services section. There you will find links for both APEX and SQL Developer Web.

Click on SQL Developer Web

This will open the application, and you will be prompted for a database user name and password.

Your ADMIN account is accessible via SQL Developer Web by default.

It’s all about the worksheet.

While SQL Developer Web has many compelling features, the biggest impact to your everyday experience with the Oracle Autonomous Database will be your ability to immediately start working with your instance via SQL and PL/SQL – directly in your browser via the SQL Worksheet.

Run queries, create objects, interact with your database with the same SQL and PL/SQL you use in SQL Developer on your desktop.

Help and Getting Started

In the Worksheet and Modeler screens, you’ll find a Binoculars button which launched a guide tour of that portion of the application.

The tour starts on your first visit to SQL Developer Web, but you can access it later any point using the Binoculars button next to the Help in the upper right hand corner of the worksheet.

And of course there is also the in-app Help and Documentation.

The underlined text at the end of the in-app feature help will navigate you to the relevant section of the Oracle Docs for SQL Developer Web.

Using APEX for the first time in Autonomous?

Yes, there’s also APEX support! When you click on the APEX link in the Console, you’ll get to here:

Click here!

And now you you’ll want to go into the admin pages…

Click that box, and you’ll be into your administration pages where you can create your first workspace and assign it to a schema.

These pages should look familiar…

So you’re saying, well how do I create a new schema for my APEX application workspace?

Try SQL Developer Web!

Now I have a schema for my APEX Workspace. Note, that I”ll need to REST enable it to login using my new thatjeffsmith user in SQL Developer Web, or call any RESTful Services in that schema:

BEGINBEGIN ORDS.ENABLE_SCHEMA(p_enabled =>TRUE, p_schema =>'THATJEFFSMITH', p_url_mapping_type =>'BASE_PATH', p_url_mapping_pattern =>'tjs', p_auto_rest_auth =>FALSE);COMMIT;END;/

If you run this above code, you’ll be able to login to SQL Developer Web. Just mind that the URL will look like this…

Note that I have /tjs/ in the URI? That’s the p_url_mapping_pattern.

Read 90 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.