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:

Most if not all of this is configurable!

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…

I prefer High Contrast Dark to Light or Dark.

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 –

Don’t like the line numbers? Turn them off!

JSON/SODA –

Remember, Ctrl+Spacebar to invoke code completion

SQL Query input area of the Create/Alter View Slider –

I hate typing COMMISSION_PCT, with a passion.

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!

I’ve been playing with my Strava data lately, expect to see more Push-Ups and less Beer in my demos.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Write A Comment