user defined tool

[oktay]

Hi, need an example configuration of a user defined tool to - execute an sql file on local disk (containing for example "select sysdate from dual;"). For execution it should use current/active-"main connection user/password" for authentication.

Help documents were not guidefull.

Thanks
Oktay

 

[oktay]

Sorry,
using PL/SQL Developer 9.0.6 / Windows 7 Ultimate

 

[Marco Kalter]

Do you want to run a SQL statement and show the result set? In that case a user-defined tool is not appropriate. You should use a report instead (File > New > Report). A report can be added to the menu.

 

[oktay]

Hi,
yes I would like to see the result set but not as a new report as you suggest because a report is not as flexible as the output from an SQL window.

Firstly, I'm trying to explore ways to show session related user-table data that will speed up my "kill of sessions(in linux)" without going to another rsh/telnet interface. I've created a few SQL statements that I can select in Tools/sessions-->LOV list but it seems like a longhand approach.

Secondly, maybe I'm wrong in seeking tools/configuration/new session. Still I would like to see how to use the "tools/configuration/new-session". Especially the way to use the #connect / #user parameters by way of an example or redirection to some other manual/document.

Thanks again
Oktay