CODEWITHSUNDEEP
text-editorplsqldevelopertextedit
user8467219
user8467219

Reputation:

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

Upvotes: 1

Views: 10272

Answers (4)

Javier Bordonada
Javier Bordonada

Reputation: 9

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

Upvotes: 1

dawncode
dawncode

Reputation: 628

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

Upvotes: 0

Valentin
Valentin

Reputation: 81

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

Upvotes: 4

user8467219
user8467219

Reputation:

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

Upvotes: 2

Related Questions