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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
100 views