'PL/SQL Developer: Change syntax to upper case

Is there a shortcut and/or command that will highlight syntax and change to upper case?

Example

select tablea.id
from  tablea

To:

SELECT TABLEA.ID
FROM TABLEA
text-editorplsqldevelopertextedit


Solution 1:[1]

Within PL/SQL Developer, go to Tools>Preferences>KeyConfiguration. Scroll down to Edit/Selection/UpperCase and you can set a shortcut.

Solution 2:[2]

With version 12.0.7.1837:

Go to Configure tab >> Preferences:

User interface >> Editor >> Keyword case >> select 'Uppercase'

This will automatically transform keywords to uppercase. However, it will not transform schema and table names (I'm not sure if there's a setting for this).

Regarding syntax highlighting, there are a few settings within the same section:

User interface >> Editor >> Syntax highlighting

Solution 3:[3]

Configuration of case change for SQL Developer Version 4.1.5.21 BUILD MAIN 21.78 Preferences -Code Editor -Completiom Insight Change case as you type screen capture here

Solution 4:[4]

I tried Alt+' on SQL DEVELOPER Version 20.2.0.175 and it working.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Valentin
Solution 3 Javier Bordonada
Solution 4 dawncode

Related Questions