Mostly Making oracle easy, mostly:
  • SQL Developer Web: Filtering Tables & Views
  • Oracle SQL Developer Web 20.4 and JSON
  • Oracle SQL Developer Web 20.4 and AutoREST
  • Translating JSON Doc Store Query By Examples (QBE) to SQL!
  • ORDS Overview – in 9 minutes!
  • Connecting via JDBC to Oracle Autonomous…via HTTPS/REST
  • 2020 Recap: Your Favorite Content
  • Working with BLOBs in Oracle SQL Developer Web
Search for:
  • Twitter
  • YouTube
  • LinkedIn
ThatJeffSmith ThatJeffSmith
  • SQL Developer
  • SQL Developer Web
  • ORDS
  • Data Modeling
  • Ask A Question
  • About
In SQL Developer

SQL Developer Web Updates for Oracle Autonomous Database

November 19, 2019 2 Mins Read
Share
Share on Facebook Share on Twitter LinkedIn Email

As of this past Friday, the 15th of November, the ORDS tier portion of Oracle Autonomous Database (Serverless) – which covers both the commercial and Always Free versions of both Data Warehouse and Transaction Processing shapes, was updated to version 19.2.1.

This had two significant impacts on the user interface for SQL Developer Web.

  • Easier sign-in process for users other than ‘admin’
  • Ability to load data from a file on your machine to a table

Signing In as users other than ‘ADMIN’

The ‘quick link’ from your OCI Autonomous Console on the Tools page still points to a hard-coded URL for logging in as your default administrator user, ‘ADMIN.’

However.

You now have an alternative URL to hit for signing in to SQL Developer. Take your URL, and instead of seeing …

.../ords/admin/sign-in or
.../ords/admin/_sdw

Change it to

.../ords/sql-developer

Which will take you to this page:

Click ‘Next’

BOOKMARK THIS PAGE. Share this URL with anyone you want to have access to your database via SQL Developer Web…provided they have valid credentials to a REST enabled schema of course.

Once you click ‘Next’, we’ll fix the Sign-In URL for you.

We’ve adjusted the URL so your login to the REST enabled schema ‘JEFF’ will work.

And voila…

Loading Data to a TABLE

It starts with a right-click on your table in the Worksheet.

Starting with an empty table…

Here’s a 90 second animated GIF of me doing a 1800+ row import from an Excel file on my computer.

Sorry for the big GIF…

Here’s a shorter version from @krisrice

Other things of note…

This is based on ORDS version 19.2.1. ORDS version 19.3 is going to be released very, very soon. And when it does, the things I’m showing you here will be available anywhere you install ORDS – not just in Oracle Cloud. We’ll of course also have it scheduled to go live in Oracle Cloud, and at that point, when you do a ‘Logout’ of SQL Developer Web, we’ll take you directly to the new /ords/sql-developer login page.

For version 19.4 of SQL Developer Web, we have works in progress for managing USERS and doing Excel/CSV imports to NEW tables, not just existing ones.

Excelgifimportloginsqldevsqldev-web
0
thatjeffsmith
Author thatjeffsmith

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

  • Website
Prev Post

Tips and Tricks – Data Edition

November 13, 2019 1 Min Read
Next Post

APEX 19.2: Faceted Search

December 4, 2019 4 Mins Read

Related Posts

SQL Developer Web: Filtering Tables & Views

January 22, 2021

Oracle SQL Developer Web 20.4 and JSON

January 20, 2021

Oracle SQL Developer Web 20.4 and AutoREST

January 19, 2021

Working with BLOBs in Oracle SQL Developer Web

December 14, 2020

Working with {JSON} in the Oracle Autonomous Database and loading documents with ORDS

December 14, 2020

Loading Data into your Oracle (Cloud) Database

December 10, 2020

2 Comments

  1. Avatar
    Holger Friedrich 1 year ago Reply

    Hi Jeff.

    Looks great, but just FYI, it does not work in Frankfurt data centre so far. Looks like only parts are deployed. The way to log in with an individual user works for admin, since one is forwarded to the regular admin login page after filling out the ‘username-only’ page first. For all users other than admin, I get an http error ‘404, page not found’.

    Regs, Holger

    • thatjeffsmith
      thatjeffsmith Post Author 1 year ago

      Yeah, this upgrade rollout started in the Ashburn data center and it’s working its way through the rest of OCI land.

Write A Comment Cancel Reply

  • Search 900+ posts
  • What it is I do here
    About Me

    I'm a product manager at Oracle - I want YOU to be happy using Database Development tools.
    I publish weekly - tips and tricks for Oracle SQL Developer, SQLcl, SQL Developer Data Modeler, and Oracle REST Data Services.

    Twitter YouTube LinkedIn
  • Your Favorite Posts
    • How to Import from Excel to Oracle with SQL Developer
    • Keyboard Shortcuts in Oracle SQL Developer
    • Top 10 Preferences to Tweak when using SQL Developer
    • Formatting Query Results to CSV in Oracle SQL Developer
    • Enabling DBMS_OUTPUT by default in SQL Developer
    • Resetting Your Oracle User Password with SQL Developer
    • How To: Generate an ERD for Selected Tables in SQL Developer
    • Migrating Oracle SQL Developer Connections (with Passwords!)
  • Subscribe - Posts Emailed To You!

  • Mostly Making Oracle Easy, Mostly

    Privacy Policy 

  • Twitter
  • YouTube
  • LinkedIn
  • Download SQL Developer
  • Developer Tools Message Boards

© Jeff Smith and ThatJeffSmith, 2019

Top
ThatJeffSmith