Shortcut to Uppercase Selected Text in Oracle SQL Developer

oracle oracle-sqldeveloper
Andrew Mairose picture Andrew Mairose · Jan 26, 2016 · Viewed 54.8k times · Source

I would like to highlight some text in a SQL Developer worksheet and convert it to uppercase with some keyboard shortcut.

Is there any such shortcut in Oracle SQL Developer?

I am using version 4.1.2.

Answer

Sentinel picture Sentinel · Jan 26, 2016

Under Tools->Preferences->Shortcut Keys you can find and/or define the shortcut key combination for the Convert Selection to Uppercase and Convert Selection to Lowercase commands. I have mine mapped to CTRL+U and CTRL+L respectively. There unfortunately does not appear to be a specific command for converting text to Initcap, so the To Upper/Lower/Initcap command is the way to go for that. However, be aware that the To Upper/Lower/Initcap command actually cycles between five format modes:

  • UPPERCASE
  • lowercase
  • Initcap
  • Lower Keywords, Upper Identifiers
  • Upper Keywords, Lower Identifiers

Some of these modes will change the behavior of the code formatter (default key sequence CTRL+F7), and the Tools->Preferences->Code Editor->Completion Insight->Change case as you type setting if you have it enabled.

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More