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 ?