While there are many different graphical user interface tools for running SQL statements, sometimes all you really want and need is a smaller, focused and thus simpler tool for modest tasks – such as opening and running a basic SQL script. For those specific, lesser needs I often utilize the popular freeware editor Notepad++. However it requires manual tweaking in order to have Notepad++ execute SQL statements via Oracle’s SQL*Plus. In this blog I’ll show you how. The goal will be to have Notepad++ look, feel and behave as shown in the Figure 1 below – where the top half of the screen displays the SQL statement, the bottom half of the screen shows the command’s output, and there is a key mapped to execute the SQL statement.
Figure 1: Notepad++ Example
Here are the steps:
Main menu -> Plugins -> Plugin Manager -> Show Plugin Manager
Available Tab, Find and check NppExec plugin (see Figure 2 below)