Re: Where should place my sql scripts?

From: Alison Holloway <Xalison.holloway_at_oracle.comX>
Date: Wed, 23 Apr 2003 10:32:49 +1000
Message-ID: <3EA5DF31.2010801@oracle.comX>

FYI, the ability to run scripts via HTTP is a feature of SQL*Plus command line, not just iSQL*Plus. It was introduced in 9.0.1 for Windows, and in other platforms in 9.2.

Alison

Rauf Sarwar wrote:

> Alison Holloway <Xalison.holloway_at_oracle.comX> wrote in message news:<3EA4FBCF.1040703_at_oracle.comX>...
> 

>>Sure, just tell SQL*Plus the path. The syntax is:
>>
>>@{url|file_name[.ext]} [arg...]
>>
>>For example:
>>
>>@c:\temp\myscripts\script.sql
>>@http://machine.com/scripts/script.sql
>>
>>Alison
>>
>>
>>Peter wrote:
>>
>>>Sqlplus is complaining that it cannot find my scipts.
>>>Can I specify where the scripts are in the sql command?
>>>
>>>
>>

> 
> 
> To add to Alison's post. I don't use iSql*Plus but on command line
> sqlplus, enclose file name in "" if there are spaces in name. e.g.
> 
> @"C:\Program Files\blah\my file.sql"
> 
> Regards
> /Rauf Sarwar

Received on Tue Apr 22 2003 - 19:32:49 CDT