We (Oracle) had a big event yesterday where Larry (THAT Larry) and our Execute Vice President Juan Loaiza debuted the newest version of our Oracle Database. Learn More/Resources watch the replay read my Live tweet commentary official Oracle Database Blog announcement 23ai feature blogs/examples It’s now also available for Autonomous Always Free in the Oracle Cloud You can have two Autonomous databases in an Always Free cloud tenancy. And if you’re in the Ashburn or Frankfurt regions (full roll-out continues even now), you can create an 23ai instance. I’ll share a ‘how-to’ article shortly on ..read more

When people want something, they’re not shy about it. I find this both refreshing and also a bit overwhelming as a human being. This tool is worthless until you add filtering. Ouch! But also, message received! And now in our 24.1 update, available as of yesterday, ye shall have said feature. By the way, we knew it was a critical feature, but there were more critical features than Jira sprints and engineers available to make it happen for our inaugural update. You’ll see more of these core, key, critical features come in over the upcoming months. Don’t show me all my tables, just the ones I car ..read more

If you’re patient, your extension should show as ready to be updated in the VS Code Marketplace. If you’re NOT patient, you can request the upgrade NOW. The ChangeLog has a few items of important notice – New Features! FILTERING – both lists of objects in the connection trees AND lists of schemas under the ‘Other Users’ node File Based PL/SQL development – open a plsql file, use the PL/SQL compiler Visual Explain Plans Filter/Search on SQL History DDL Generation preferences Bug Fixes!! Again, this is for the most part due to the great feedback we’re getting from both the Marketplace Q&A ..read more

Our scenario: You have an OAuth2 Client for your Oracle Database REST APIs, defined in database 1, let’s call that environment, DEVELOPMENT. And you’re ready to move your REST Modules and/or AutoREST enabled objects into say environment 2, UAT. And, you have decided you want to have the client SECRET be the same between said environments. How could you achieve this? TL/DR: export client using ORDS_EXPORT.EXPORT_OAUTH_CLIENT retrieve the current secret (stow that step 4) re-create the CLIENT using output from step 1 reset the SECRET with value retrieved from step 2 with OAUTH.UPDATE_CLIENT_SEC ..read more

We have this feature in old school SQL Developer where you can have ‘important’ connections outlined with a color scheme…the connection name is also given this color. It ‘works’ I would say, but is it ideal? As we’re re-creating our SQL Developer world inside of VS Code, we know what works, we know what people like, we know what people NEED. But, does it makes sense to do a 1:1 lift-and-shift for every feature? This is one of those features that WILL get done, but the implementation may be different. For example, did you know you can ALREADY have fun with your connection names? Is this enough ..read more

Download ORDS ORDS 24.1 Release Notes I won’t read the release notes for you, but I will summarize. Consider this your TL;DR summary! Core ORDS By ‘core ORDS’ – I mean the basic ‘guts’ of the Oracle REST Data Services software. One of changes is significant. Metadata Caching enabled by default with a default timeout of 1 second This means heavy consumers of REST APIs, esp those of the AUTO variety, could see as much as 3x faster response times. That’s pretty cool. Note we’ve just changed the ‘DEFAULT’ behavior – you can always go into the config and turn this off, explicitely. Run ‘ords co ..read more

Kris and I met with around 230 of you yesterday for an hour to talk about all things SQL Developer, it’s future, and specifically our VS Code Extension. Missed that webinar? No worries, you can watch it on YouTube! Use this link to jump STRAIGHT to the live-demo portion. It’s an hour, with powerpoint, me talking, AND some live demo.Sneak Peek on what we’re working on In no specific order.. 1. Visual Explain Plans Look familiar, maybe? We built this first for SQL Developer Web 2. Filtering You’ll be able to filter both objects in the tree and also schemas (under Other Users), just like in the ..read more

With a general availability of Oracle Database 23c for all customers just around the corner, I thought I’d spotlight a minor new feature, via a REST API. Let’s create a dummy table. CREATE TABLE IF NOT EXISTS HR.NEW_OLD_DEMO ( ID NUMBER GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 CACHE 20 ) , NAME VARCHAR2 (50) , SALARY NUMBER ) LOGGING ; ALTER TABLE HR.NEW_OLD_DEMO ADD CONSTRAINT NEW_OLD_DEMO_PK PRIMARY KEY ( ID ) USING INDEX LOGGING ; And put some data in it. insert into NEW_OLD_DEMO (NAME, SALARY) values ('Smitty', 10), ('Kristopher', 20 ), ('Larry', 30); I’m actual ..read more

SQLcl is 9 years old , having made it’s introduction with SQL Developer version 4.1 back in 2015!!! We’ve added a ton of features in that period of time, and we’re continuing to build out even more! Our upcoming 24.1 release will be adding some task management features where you can execute things on a background process. Stay tuned or updates! But in today’s post, I wanted to just do a quick reminder of what you can do from your command-prompt, when working with your Oracle Database. What can it do? Basically, everything. First things first, requirements You only need SQLcl, and a copy of Jav ..read more

Snippets.. We ship some for you. You can see them on the bottom left panel under your connections, and they’re the same we have in SQL Developer desktop. VS Code is quite generous about matching these…maybe TOO generous? But the best suggestions are sorted to the top. What is you wanted to add some of your own? Now, I’ve always found code templates to be more interesting than code snippets. But in VS Code these two SQL Developer ideas have been merged into one, glorious animal. Old School – Ok…but what do those brackets do? And when you go to use these in SQL Developer – Wait Jeff, you HATE SE ..read more