| Is it possible to get SQL*Plus to recognise windows shortcuts [message #374754] |
Thu, 28 June 2001 10:53  |
John Guy
Messages: 8
Registered: June 2001
|
Junior Member |
|
|
We are using SQL*Plus 3.3 and windows 95.
I am trying to place all our SQL code into one directory on a shared server and use windows shortcuts on individual PC's to call the code in SQL*Plus sessions, unfortunately SQL*Plus claims it is unable to open the file. I assume it is because it thinks the shortcut contains the code and is not following the link.
I know we could create files containing the @path\run.sql commands instead of shortcuts but I'd rather use shortcuts because work for other programs i.e. text editors.
If you think you can help but have questions on the above please do not hesitate to mail me.
Help.
|
|
|
|
| Re: Is it possible to get SQL*Plus to recognise windows shortcuts [message #374755 is a reply to message #374754] |
Thu, 28 June 2001 13:00  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi
If the sql scripts are on one shared directory
can't you map the drive to your local PC
and run the query from sqlplus.
Like if the shared drive is in serverA with ip 192.168.100.1 then
from your local workstation you can
start/run
\\192.168.100.1
this will open an explorer and show the shared dirctories in that server.
right click on the shared sqlscripts dir
and select map the drive to some letter
for example J
then you can run your sqls
SQL> @J:\sqlscripts\mysql.sql
Bala.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
