Earlier this year we introduced a significant upgrade to the Editor component in Database Actions. It came with quite a few features, including a new look and feel.
The default display is pretty…light. But let’s take a look at what you get, ‘out-of-the-box’, and identify a few features:
![](https://www.thatjeffsmith.com/wp-content/uploads/2021/09/image-7-1024x527.png)
To the Preferences!
To get started, click on the ‘Dropdown’ Arrow indicator next to your login user displayed in the upper-right-hand-corner.
Here’s a quick little tour…
![](https://www.thatjeffsmith.com/wp-content/uploads/2021/09/db-actions-editor-gif.gif)
These changes will persist on your machine’s browser for this DB/User going forward.
It’s not just the SQL Worksheet!
The same look and feel will be shown wherever we’re displaying ‘code.’
REST Workshop –
![](https://www.thatjeffsmith.com/wp-content/uploads/2021/09/image-8-1024x663.png)
JSON/SODA –
![](https://www.thatjeffsmith.com/wp-content/uploads/2021/09/image-9-1024x823.png)
SQL Query input area of the Create/Alter View Slider –
![](https://www.thatjeffsmith.com/wp-content/uploads/2021/09/image-10-1024x589.png)
And don’t forget the Command Palette!
I’ve talked about this a few times before, but there’s a lot of power available behind this editor (the same code base responsible for what you see in VS Code aka Monaco) – the Command Palette.
You can invoke this with Ctrl+Shift+P (Windows) or Cmd+Shift+P (OS X). (Keyboard Shortcut Docs)
There’s a ton of commands you can invoke from there, search, replace, upper, lower, Zoom, remove trailing spaces, remove comments, etc.
Here’s a quick animated GIF demo I created for the @oraclesqldev Twitter account this morning. A good follow for SQLDev tips!
![](https://www.thatjeffsmith.com/wp-content/uploads/2021/09/cmd-palette.gif)