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
Useful Features in SQL Developer Web…that you might be overlooking!
SQL Developer

Useful Features in SQL Developer Web…that you might be overlooking!

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

Sell Me on Oracle SQLcl in 50 Seconds
SQL Developer

Sell Me on Oracle SQLcl in 50 Seconds

ORDS

Batch Loading CSV to Oracle Database, Again, via REST APIs

October 26, 2022
ORDS
In ORDS

Downloading files in Oracle by name via REST APIs

October 25, 2022 3 Mins Read

Downloading files in Oracle is easy when you’re using Oracle REST Data Services to build REST APIs. Here’s an example for downloading them by name.

SQL Developer
In SQL Developer

What’s Next for Oracle SQL Developer? A quick, sneek-peek.

October 24, 2022 3 Mins Read

What’s next for Oracle SQL Developer? It’s time for our platform to evolve for the modern database developer. Here’s a quick sneak-peek!

Database Stuff
In Database Stuff

Free Cloud World Digital Pass & Our Database Tools Survey

October 13, 2022 2 Mins Read

Get a free Cloud World Digital Pass! Also, we’re asking you to take a short survey on help us improve our Oracle Database Tools.

ORDS
In ORDS

Oracle Explain Plan, our new viewer in SQL Developer Web

October 7, 2022 6 Mins Read

We have a new way to display an Oracle Explain plan in Oracle SQL Developer Web. Here’s a guided tour!

ORDS
In ORDS

Oracle ORDS 22.3 is now available for download

October 6, 2022 3 Mins Read

Release announcement for ORDS 22.3! Oracle REST Data Services version 22.3 is now available and here’s a high level overview.

ORDS
In ORDS

3 ORDS REST API Tips/Tricks for Oracle Developers

October 6, 2022 4 Mins Read

Here are 3 ORDS REST API Tips I think every Oracle Developer should know!

SQL Developer
In SQL Developer

SQLcl 22.3 is now available & major updates for Liquibase

October 4, 2022 2 Mins Read

SQLcl 22.3 is now available! The big news for this Oracle release is the major updates available for the Liquibase functionality. New commands, new features!

Database Stuff
In Database Stuff

JSON and SQL, easy with Oracle, and fun with our tools!

September 28, 2022 12 Mins Read

JSON and SQL – things you come into contact almost every day. Do you use them together? With Oracle, that’s easy! Examples that might help you get started –

SQL Developer
In SQL Developer

Oracle SQL Developer for the Mac: Easy & Fast!

September 12, 2022 2 Mins Read

Oracle SQL Developer for the Mac is now available with embedded Java Home for Apple Intel and ARM based CPUs. Easier installs & faster!

ORDS
In ORDS

Configuring Java for ORDS and SQLcl

September 9, 2022 3 Mins Read

Configuring Java for ORDS and SQLcl can be as easy as setting an Environment Variable. I’ll show you how with a couple of examples.

ORDS
In ORDS

Adding HTTP(S) Access Logs for ORDS Standalone

September 8, 2022 2 Mins Read

How to enable web access logs ORDS – instructions for Oracle REST Data Services (ORDS) version 22.1 and higher.

TL/DR: set standalone.access.log

ORDS
In ORDS

Python & REST APIs: Testing my Oracle Autonomous Database

September 2, 2022 7 Mins Read

My first python program! Getting and using a OAuth2 bearer token in an Python app to call Oracle Database REST APIs (ORDS).

ORDS
In ORDS

JSON_OBJECT_T and ORDS: what’s the ‘best way?’

August 31, 2022 3 Mins Read

JSON_OBJECT_T and ORDS: Question: what’s the best way to use these together for building a REST API? Answer: here is ONE easy solution.

ORDS
In ORDS

Manage & Monitor Oracle Database with REST APIs.

August 30, 2022 6 Mins Read

Monitor Oracle Database with REST APIs – without writing any code! it’s all included with Oracle REST Data Services (ORDS).

Previous1 2 3 4 … 72Next
  • 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
  • StackOverflow
    profile for thatjeffsmith on Stack Exchange, a network of free, community-driven Q&A sites
  • 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