Home » SQL & PL/SQL » Client Tools » about SAVE environment sqlplus command ....
about SAVE environment sqlplus command .... [message #228155] Sun, 01 April 2007 17:20 Go to next message
m_arafa
Messages: 36
Registered: June 2006
Member
hi all,

when i write :-

...
SQL> save qry

this file is created in BIN directory , even though i type in 'REGEDIT' system file
in oracle directory
in SQLPATH 'D:\wok' only, not additional paths

thanx,
Re: about SAVE environment sqlplus command .... [message #228157 is a reply to message #228155] Sun, 01 April 2007 17:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
To my knowledge, SQLPATH sets the path where files will be executed FROM, not where they will be saved to. To save the file to a specific directory, you could just specify the path in addition to the filename.
Re: about SAVE environment sqlplus command .... [message #228184 is a reply to message #228157] Mon, 02 April 2007 00:46 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Furthermore, if you run SQL*Plus from the operating system command prompt (by typing "SQLPLUS username/password") instead of (on MS Windows) selecting it from "Programs - Oracle - Application Development - SQL*Plus", all files will be saved in a current directory.

For example:
M:\>sqlplus scott/tiger@ora10

SQL> select count(*) from dept;

  COUNT(*)
----------
         4

SQL> save cnt_dept.sql
Created file cnt_dept.sql
SQL> exit

M:\>dir cnt_dept.sql
 Volume in drive M is file sharing 1
 Volume Serial Number is 98A9-A7AE

 Directory of M:\

02.04.2007  07:41                30 cnt_dept.sql
               1 File(s)             30 bytes
               0 Dir(s)  1.130.334.281.728 bytes free

M:\>
Re: about SAVE environment sqlplus command .... [message #228212 is a reply to message #228184] Mon, 02 April 2007 01:50 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Forgot to mention ... if your SQL*Plus icon is on a desktop (MS Windows again), change its "Start in" property to desired directory (in your case, it would be "D:\wok").
Previous Topic: quest software - spotlight on oracle(bit urgent)
Next Topic: Alternative to TOAD and SQL Oracle Developer
Goto Forum:
  


Current Time: Sun Dec 04 12:54:30 CST 2016

Total time taken to generate the page: 0.05130 seconds