Mostly Making oracle easy, mostly:
  • Quick Tip: SQL Monitoring Reports for your REST APIs
  • SQL Worksheet for ANY database in the Oracle Cloud
  • Getting started with the new SALES_HISTORY, 2023 edition
  • The Magic of Excel + Oracle, powered by REST APIs
  • TAB Completion in SQLcl, your modern command line for Oracle
  • Dropping an Oracle table with SQLcl and Liquibase
  • REPEAT after me, it’s easy to monitor with Oracle SQLcl!
  • SQL Developer 23.1 and the Instant Client
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

SQL Worksheet for ANY database in the Oracle Cloud

May 24, 2023

The Magic of Excel + Oracle, powered by REST APIs

May 18, 2023

TAB Completion in SQLcl, your modern command line for Oracle

May 17, 2023

Dropping an Oracle table with SQLcl and Liquibase

May 16, 2023

REPEAT after me, it’s easy to monitor with Oracle SQLcl!

May 12, 2023

SQL Developer 23.1 and the Instant Client

May 3, 2023

2 Comments

  1. Avatar
    Holger Friedrich 4 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 4 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 this site
  • Looking for help?

    I'm a product manager for Oracle Database,
    publishing tips and tricks for SQL Developer, SQLcl, Data Modeler, and REST Data Services (ORDS)

    Twitter YouTube LinkedIn
  • Tweets by @thatjeffsmith

  • 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
    • How To: Generate an ERD for Selected Tables in SQL Developer
    • Formatting Query Results to CSV in Oracle SQL Developer
    • Resetting Your Oracle User Password with SQL Developer
    • Die! Or How to Cancel Queries in Oracle SQL Developer
  • Don’t miss a single post! Enter e-mail to subscribe.
  • Mostly Making Oracle Easy, Mostly

    Privacy Policy 

  • 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, 2023

Top
ThatJeffSmith