
ThatJeffSmith
4,431 FOLLOWERS
ThatJeffSmith blog is about tips and tricks for Oracle SQL Developer, SQLcl, SQL Developer Data Modeler, and Oracle REST Data Services. My primary goal is to help you save time when working with Oracle Database. If I can ALSO make what you’re currently doing a little more fun, then that’s a big bonus for me.
ThatJeffSmith
4d ago
Oracle SQLcl 24.4.1 is available, and supports loading Excel files to new or existing tables with the LOAD cmd. Plus a reminder about our Project feature.
The post Oracle SQLcl 24.4.1 available with Excel & Access imports first appeared on ThatJeffSmith ..read more
ThatJeffSmith
5d ago
With the latest innovations in Oracle 23ai, you can now work with an Oracle session transaction over MULTIPLE HTTPS REST API calls! Here's a demo with ORDS.
The post Sessionless Transactions in Database 23ai & your REST APIs first appeared on ThatJeffSmith ..read more
ThatJeffSmith
2w ago
Round-up from my 'daily share a Oracle Database blog post in January' project. All of the posts, links to the authors, and my personal takes.
The post Oracle Database blogs to add to your RSS feeds first appeared on ThatJeffSmith ..read more
ThatJeffSmith
3w ago
How to easily load a new record to your Oracle Database table via a REST API, when that table has 1 or more JSON columns in either 19c or 23ai via ORDS.
The post Loading JSON data into both 19c & 23ai tables via REST APIs first appeared on ThatJeffSmith ..read more
ThatJeffSmith
3w ago
A quick look at one of our new features in Oracle SQL Developer Extension for VS Code - reports! Quickly get information about your database.
The post Oracle SQL Developer Extension for VS Code: Reports! first appeared on ThatJeffSmith ..read more
ThatJeffSmith
1M ago
Creating or Cloning Pluggable Databases (PDBs) via ORDS Database REST APIs is now an asynch operation via DBMS_SCHEDULER jobs. Here's an example.
The post A quick note on Creating PDBs using REST APIs with ORDS first appeared on ThatJeffSmith ..read more
ThatJeffSmith
1M ago
Oracle Cloud Infrastructure (OCI) Console now supports Oracle SQL Developer Web! SQL worksheet, data modeler, sql monitoring, user management, and more!
The post Introducing SQL Developer Web to Oracle Cloud Infrastructure first appeared on ThatJeffSmith ..read more
ThatJeffSmith
1M ago
An overview for all the different ways to get and view the plans for your SQL statements in Oracle Database using the SQL Developer extension for VS Code.
The post Execution plans in Oracle SQL Developer for VS Code first appeared on ThatJeffSmith ..read more
ThatJeffSmith
2M ago
Here's a quick start guide of sorts if you're an old-time Oracle SQL Developer user and you want to get started using the SQL Developer Extension for VS Code.
The post Definitive guide to moving from SQL Developer to VS Code first appeared on ThatJeffSmith ..read more
ThatJeffSmith
2M ago
We've updated our Oracle VirtualBox Database 23ai appliance. The Oracle Database is now running version 23.6.
Simply download, import, and run!
The post Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6 first appeared on ThatJeffSmith ..read more