I am migrating to a Windows 7 64-bit workstation, with Oracle 11g tools. So my old friend, the Windows GUI version of SQL Plus (sqlplusw.exe) is no longer available.
In my day-to-day work, I need to navigate to a specific directory where scripts related to a particular task or job are stored. In the GUI version of SQL Plus, I could use the File, Open menu option, open a little sql script, and that changed the directory SQL Plus used. Then, I could run any sql script in that directory by simply typing @ScriptName.
Now using the dumb Windows cmd.exe-style window, I don't know how to change the currently designated path. I have tried Host CD [new path], but that does not work. I apologize if I am missing something obvious, but I could sure use some help.
(BTW... Does anyone have a 64-bit version of sqlplusw.exe on their machine? It would have been installed with a 64-bit version of Oracle 10g for Windows. )
P.S. I tried posting this earlier, but cannot seem to find the post. Apologies if it shows up twice.