Oracle Database 23 Feature: Returning OLD VALUE via REST
ThatJeffSmith
by thatjeffsmith
1w ago
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
Visit website
Oracle SQLcl: Easy Command Line access to your Database
ThatJeffSmith
by thatjeffsmith
1w ago
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
Visit website
Adding Custom Snippets in VS Code for SQL Developer
ThatJeffSmith
by thatjeffsmith
3w ago
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
Visit website
Oracle SQLDev extension for VS Code Update, 23.4.1
ThatJeffSmith
by thatjeffsmith
1M ago
We’ve just published our first update! Go get it! Big thanks to all of our early adopters who shared feedback, primarily on the Extension Marketplace Q&A and our Forums. Based on that feedback, we’ve identified and fixed a couple dozen bugs and opportunities for improvement. You can see the entire changelog here. But I want to call out a couple of the biggest ones. Fix #1: Default to Best Fit on the Grids Done! When you browse a table or run a query, we’ll apply a ‘best fit’ to the column sizing. Still pending: an extension preference to set your Default column sizing (Best Fit, To Header ..read more
Visit website
Assign/Change Keyboard Shortcuts in SQL Dev for VS Code
ThatJeffSmith
by thatjeffsmith
1M ago
For our new VS Code Extension, Peter asks – One thing I didn’t see requested in other reviews is hot key mapping. I’m used to having control-e mapped to the execute button instead of control-enter. Yes, you can do this! Keyboard shortcuts are all defined in one place, you won’t find them under the VS Code Extension preferences. Open VS Code’s Keyboard Shortcuts Right click in an editor and open the Command Palette, or use Ctrl+Shift+P Select, ‘Open Keyboard Shortcuts’ Search for SQL Developer and Run Click the Pencil/Edit Icon Note that Ctrl+E won’t work for me as there are already 3-4 OTHER ..read more
Visit website
Why is my VS Code Extension (SQL Developer) not working?
ThatJeffSmith
by thatjeffsmith
1M ago
This is NOT a post where I will tell you there are ‘good’ and ‘bad’ extensions for VS Code. I am here to say that there might be some extensions out there that can cause conflicts, thereby making our SQL Developer features…inaccessible. I’m still learning the in’s and out’s of VS Code, but one of the core concepts or features you’re going to want to get familiar with are Workspaces. But, more on this later. Problem: Why can’t I execute my .SQL files? I’ve gotten this question a few times, and my answer is, well of course you can! Simply pick your connection and hit the ‘Run’ button(s)! Like so ..read more
Visit website
SQLDev for VS Code: Simple Command Line Integration
ThatJeffSmith
by thatjeffsmith
1M ago
It’s fun to watch developers get into heated arguments over VI versus Emacs or what the best dark mode theme is in VS Code, but in database land there’s been a simmering debate over what’s best between GUI apps and the SQL prompt. Typing, mostly Point, click, type… You don’t have to pick one. For the first time we’re now directly integrating the command line experience provided by SQLcl directly into SQL Developer, via our new VS Code Extension. What does this mean? 1. No SQLcl install required It’s included WITH the Extension. So if you want a ‘single install’ to be up and running for Oracle ..read more
Visit website
Working with objects in your Oracle Database with VS Code
ThatJeffSmith
by thatjeffsmith
2M ago
Step 1: Have you installed our extension? Stop. Do not pass Go! In VS Code, pull up the Extensions panel, and search for ‘Oracle SQL Developer.’ Or, click here. There are many ‘SQL’ and ‘database’ type extensions out there, be sure to disable them before activating SQL Developer, so that you get the full list of features. Then just click the ‘Install’ button, and once it’s available, you’ll see this icon, which you’ll click to activate. Once you’ve defined a connection, you can start to explore your schema(s)!Let’s talk about viewing and working with your objects First some known issues and q ..read more
Visit website
Navigating your schemas/databases in SQLDev for VS Code
ThatJeffSmith
by thatjeffsmith
2M ago
People starting to take a look at and use our new VS Code Extension – THANK YOU! And some of you are starting to ask questions. Questions like, “Hey, where is the schema browser?” And I’m saying, “I hear you, but this is effectively version 1.0 of the product – stay tuned!” But let’s talk about what you can do RIGHT NOW. Your schema & the Tree Find your object type, expand, click to open the object. Intuitive, I hope. Your requests also include: filters, we need filters because we have lots of tables! can we disable opening the object just because we clicked on it? We hear you, and we’re ..read more
Visit website
Go to Declaration vs Peek in SQLDev for VS Code
ThatJeffSmith
by thatjeffsmith
2M ago
Fun fact, I have to think VERY hard before typing ‘peak’ vs ‘peek.’ Today I want to highlight some of the language server protocol support build into our VS Code extension for the SQL and PL/Language, specifically – A peak is something you climb, or admire from a distance.Go to Declaration This one is pretty obvious, you have some Oracle database code (SQL or PL/SQL), and you want to go look at the object being referenced in your code. The simplest example would be something like – select * from hr.employees; So let’s do it – Yes, we’re going to fix the default column sizing in our data grid ..read more
Visit website

Follow ThatJeffSmith on FeedSpot

Continue with Google
Continue with Apple
OR