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!
Troubleshooting guide for starting up Oracle REST Data Services and invalid connection pools. Bad passwords, user accounts, and more.
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!
2022 review – A look back on what happened with me in 2022 and what might be happening in 2023 with thatjeffsmith (or, just Jeff).
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 and Oracle REST Data Services (ORDS) versions 22.4 are now available for download! New command in SQLcl: ‘argument’
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.
How to enable REST API debug messages for your ORDS endpoints in Oracle Autonomous Database – just use ORDS_ADMIN.SET_PROPERTY() !
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.
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!