Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Formatting Issues in SQL Developer

AnnelizeFJun 5 2025 — edited Jun 5 2025

I am using the latest version for SQL Developer: 24.3.1.347 and struggling with some of the editor's formatting options.

  • I know that I can format my code using Ctrl + F7
  • I am happy with all the basic formatting tools via Tools > Preferences > Format

However, I want to be able to do the following and I'm not sure how to go about it

  1. Add some reserved words / keywords i.e ROWTYPE is not recognised in the same way as TYPE
  2. Change the way my ‘SELECT * FROM.. WHERE’ is formatted
  3. Change the default formatting and naming prefences when I create a package via right clicking on table name in the browser > table > Generate table API

I am from a TOAD background and I understand that not all of these options might be available in a free client, but I'm hoping someone's played with and succesfully changed some of these settings.

Thanks

Annelize
This post has been answered by thatJeffSmith-Oracle on Jun 6 2025
Jump to Answer
Comments
Post Details
Added on Jun 5 2025
3 comments
165 views