Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change sqlplus current path dynamically?

WPSmodJan 27 2015 — edited Jan 28 2015

I am moving to an Oracle 11g environment, so have to let go of my old friend, sqlplusw (windows gui version).

The most pressing issue is how to change the path within the running window.  In the Windows version of SQL Plus, all I needed to do was a File, Open, navigate to a new directory, and open any .sql script in the new directory.  Then I could run any .sql script within that directory by typing @ScriptName

In the non-gui sqlplus, I have tried Host CD [new path name] but that does not seem to work.

What is the trick in the dumb windows cmd.exe style window?

(...By the way, does anyone happen to have a Windows 64-bit version of sqlplusw.exe (last supplied with 64-bit Oracle 10g for Windows)?  )

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2015
Added on Jan 27 2015
6 comments
1,085 views