Need help regarding notepad++ integration with plsql [message #523884] |
Tue, 20 September 2011 23:06 |
|
sultan1205
Messages: 4 Registered: September 2011 Location: Bangladesh
|
Junior Member |
|
|
Hi guys, i am trying to make notepad++ my default plsql editor.
that means when i double click plsql.exe then notepad++ should open up.
i am using oracle 11g.
I would be glad if some one could help me out.....
|
|
|
|
|
|
|
|
|
|
Re: Need help regarding notepad++ integration with plsql [message #524026 is a reply to message #524019] |
Wed, 21 September 2011 07:35 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
*Maybe* I found the way:
- Run Notepad++
- Press F6 (executes NppExec plugin) or go to Plugins - NppExec - Execute ...
- Into the Command(s) window, put the following lines:
npp_save
cd $(CURRENT_DIRECTORY)
sqlplus scott/tiger@ora10
It is supposed to
- save the current file
- go to current directory
- start SQL*Plus
- The Console window is opened, with you connected as Scott:
- Now edit your SQL script, save it. Run it in the Console window using "@file_name" syntax:
I'm not that smart myself, great help was this walkthrough.
I don't know whether it is possible to run the current file using some keyboard shortcut (yes, I saved my NppExec plugin command script, created a shortcut (Ctrl + E), but this just opens a console, it doesn't run the SQL script itself).
Maybe someone else knows how to do that; for me, @file_name is good enough.
-
Attachment: npp_2.png
(Size: 56.48KB, Downloaded 6258 times)
-
Attachment: npp_1.png
(Size: 43.59KB, Downloaded 6300 times)
|
|
|
|
|
|