Does a better simple editor exist besides notepad that you can use to right SQL code/statements?
If you have a test editor of your choice on the machine where you work, you can always set the '_editor' SQL*Plus variable to use that editor.
I use "Textpad" and I love it.
Lets you do a lot of little things that save a LOT of time.
-set colors to key words (any color you like)
-paste stuff as a block (instead of lines)
-make changes to a GROUP of files (like replace all, but to 50 files at once)
-show line-numbers and spaces
many other helpful things as well.
I use Textpad as well . Love the editor .
Click Here to Expand Forum to Full Width