Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Shortcut to Uppercase Selected Text in Oracle SQL Developer

Tags:

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.

like image 486
Andrew Mairose Avatar asked Jan 26 '16 15:01

Andrew Mairose


People also ask

How do I make text uppercase shortcuts?

To use a keyboard shortcut to change between lowercase, UPPERCASE, and Capitalize Each Word, select the text and press SHIFT + F3 until the case you want is applied.

How do you capitalize all letters in Oracle?

The UPPER() function returns a string with all letters in uppercase.

How do I create a shortcut in SQL Developer?

Open the directory where the SQL Developer 3.0 is located, right-click sqldeveloper.exe (on Windows) or sqldeveloper.sh (on Linux) and select Send to > Desktop (create shortcut). 2 . On the desktop, you will find an icon named Shortcut to sqldeveloper.exe.


1 Answers

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.

like image 198
Sentinel Avatar answered Sep 30 '22 07:09

Sentinel