Mostly Making oracle easy, mostly:
  • ORDS & SQL Developer Web 22.4.2 – Self Service Schemas
  • Generating DDL for your Oracle objects in SQL Developer Web
  • Hours wasted watching Grey’s Anatomy? Finding out with SQL!
  • Learning SQL using Spotify II: Functions, Group By, & Dates
  • Learning SQL with your own Spotify Streaming History data
  • Troubleshooting ORDS startup errors, the pool is invalid.
  • Create a ORDS REST API in a single PL/SQL call
  • Physical Properties in Oracle TABLE Liquibase changeSets
Search for:
  • Twitter
  • YouTube
  • LinkedIn
ThatJeffSmith ThatJeffSmith
  • SQL Developer
  • SQL Developer Web
  • REST APIs
  • Data Modeling
  • Ask A Question
  • About
In SQL Developer

SQL Developer Web Updates for Oracle Autonomous Database

November 19, 2019 2 Mins Read

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
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

ORDS & SQL Developer Web 22.4.2 – Self Service Schemas

January 31, 2023

Generating DDL for your Oracle objects in SQL Developer Web

January 26, 2023

Hours wasted watching Grey’s Anatomy? Finding out with SQL!

January 23, 2023

Learning SQL with your own Spotify Streaming History data

January 17, 2023

Physical Properties in Oracle TABLE Liquibase changeSets

January 4, 2023

Run Liquibase updates for a specific schema with SQLcl

December 19, 2022

2 Comments

  1. Avatar
    Holger Friedrich 3 years 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 3 years 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 1,000+ posts
  • What it is I do here

    I'm a product manager at Oracle, and
    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
    • Enabling DBMS_OUTPUT by default in SQL Developer
    • Top 10 Preferences to Tweak when using SQL Developer
    • Formatting Query Results to CSV in Oracle SQL Developer
    • How To: Generate an ERD for Selected Tables in SQL Developer
    • Resetting Your Oracle User Password with SQL Developer
    • Die! Or How to Cancel Queries in Oracle SQL Developer
  • Enter your email address
  • Mostly Making Oracle Easy, Mostly

    Privacy Policy 

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

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle. © Jeff Smith and ThatJeffSmith, 2021

Top
ThatJeffSmith