Mostly Making oracle easy, mostly:
  • 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
  • 2022 Review & What’s Coming in 2023
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

SQL Developer

Generating DDL for your Oracle objects in SQL Developer Web

January 26, 2023
Database Stuff
In Database Stuff

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

January 23, 2023 7 Mins Read

How to take your personal NETFLIX streaming data and import it to Oracle Database, then use SQL to find out how much time we’ve wasted.

Database Stuff
In Database Stuff

Learning SQL using Spotify II: Functions, Group By, & Dates

January 18, 2023 8 Mins Read

A deeper look at our Spotify streaming data that we’ve imported into our Oracle Database. Here I share a few interesting SQL queries and explain how they work.

Database Stuff
In Database Stuff

Learning SQL with your own Spotify Streaming History data

January 17, 2023 7 Mins Read

Importing your personal data from Spotify to a database for learning SQL can be done in just a few clicks with Oracle’s Always Free Autonomous Database!

ORDS
In ORDS

Troubleshooting ORDS startup errors, the pool is invalid.

January 10, 2023 8 Mins Read

Troubleshooting guide for starting up Oracle REST Data Services and invalid connection pools. Bad passwords, user accounts, and more.

ORDS
In ORDS

Create a ORDS REST API in a single PL/SQL call

January 6, 2023 2 Mins Read

Oracle REST Data Services (ORDS) comes with a PL/SQL API you can use to quickly publish a TEST module, aka ‘Hello, World!’

SQL Developer
In SQL Developer

Physical Properties in Oracle TABLE Liquibase changeSets

January 4, 2023 2 Mins Read

Turning on or off storage properties for your Oracle Database objects in your SQLcl Liquibase changeSets. Don’t want the tablespace? Use the ‘set ddl’ command!

General
In General

2022 Review & What’s Coming in 2023

January 2, 2023 7 Mins Read

2022 review – A look back on what happened with me in 2022 and what might be happening in 2023 with thatjeffsmith (or, just Jeff).

SQL Developer
In SQL Developer

Run Liquibase updates for a specific schema with SQLcl

December 19, 2022 3 Mins Read

How to run Liquibase updates for a specific schema with Oracle SQLcl. Log in as one user, deploy changeSets to another with your favorite Oracle Database cli.

SQL Developer
In SQL Developer

How to use JSON, XML, YAML Liquibase changeSets in SQLcl

December 13, 2022 3 Mins Read

JSON, XML, YAML Liquibase changeSets – you can run those in Oracle SQLcl and here are some examples! Create a table, add columns, and insert rows.

oracle sqlcl argument command for defining default values in sql scripts ORDS
In ORDS

ORDS & SQLcl 22.4 are now available for download

December 12, 2022 3 Mins Read

Oracle SQLcl and Oracle REST Data Services (ORDS) versions 22.4 are now available for download! New command in SQLcl: ‘argument’

ORDS
In ORDS

Cloud World 2022: Database Tools Tips & Tricks Video

November 29, 2022 2 Mins Read

Database Tools Tips & Tricks from Oracle Cloud World 2022. YouTube recording of my 30 minute presentation on SQL Developer, ORDS, and SQLcl.

ORDS
In ORDS

Tuning REST APIs for Oracle Database – it’s probably the SQL

November 2, 2022 10 Mins Read

Tuning REST APIs for Oracle Database often comes down to tuning the SQL that powers them. Here’s some advice and an example of how that could be done.

ORDS
In ORDS

How to enable REST API debug messages for ORDS & Autonomous

October 27, 2022 5 Mins Read

How to enable REST API debug messages for your ORDS endpoints in Oracle Autonomous Database – just use ORDS_ADMIN.SET_PROPERTY() !

ORDS
In ORDS

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

October 26, 2022 11 Mins Read

How to create a database in less than 5 minutes, create a table, then batch loading CSV to Oracle – using only REST APIs!

Previous1 2 3 … 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