Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic SQL*PLUS Question
Default the file will be stored in the current directory. When you type: save /tmp/count.sql the file will be stored in /tmp/count.sql.
Note: you must turn on the permissions to write in that directory.
Chinna wrote:
>
> Hi,
>
> How to specify the directory/find out default directory where SQL*PLUS
> stores the SQL scripts.
>
> example :
>
> SQL> select count(*) from tab;
>
> 15
>
> SQL> save count.sql
> cannot create save file
>
> Any ideas/suggestions are appreciated.
>
> Thanks
> Chinna
Received on Wed Nov 05 1997 - 00:00:00 CST
![]() |
![]() |