Re: Where should place my sql scripts?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 22 Apr 2003 09:17:03 -0700
Message-ID: <92eeeff0.0304220817.6c462188@posting.google.com>

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 - 11:17:03 CDT