Skip to Main Content

SQL & PL/SQL

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!

Your favourite text editor, SQL formatter

York35Mar 24 2017 — edited Mar 30 2017

I just want to know what text editors do DBAs, Oracle PL/SQL developers use ?

I have been using Textpad for 8 years now and I am satisfied with its features.

I used Notepad++ for 2 days . In Notepad++ , if I select a word , every occurence of this word gets highlighted in light green colour in the file. This is Notepad++'s default setting.I think it is called 'Smart Highlighting' in Notepad++  . This basic feature is not present in textpad unfortunately.

But , I didn't like the interface of Notepad++ , hence went back to Textpad.

How about formatting SQLs ? Do you guys use any tool/website to format large unreadable SQL ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2017
Added on Mar 24 2017
34 comments
7,306 views