Re: Suffix for files containing SQL commands

From: Eric Kimble <ekimble_at_wfl.fha.dot.gov>
Date: Wed, 06 Nov 2002 12:41:04 -0800
Message-ID: <3DC97E60.FCC7B719@wfl.fha.dot.gov>

George,
Suffix is the default suffix that SQL*Plus will recognize when starting scripts. Not for saving them. If you have set suffix to 'sql' then you should be able to run your scripts like
SQL>@myscript

This has nothing to do with saving a file and having SQL*Plus append the suffix on your filename, that is still up to you.

Check out the SQL*Plus reference at tahiti.oracle.com for more info.

Eric

Lekeas GK wrote:

> Hi All,
>
> I want to be able to set the default suffix for files containing sql
> commands to the null string (that is, I want to be able to save a file
> with an sql script as script rather than having to save it as script.sql
> so that I would be able to run it as @script).
>
> I tried set suffix "" and set suffix '' in my login.sql script to no
> success.
>
> Could somebody please help me with that ? We are using Oracle 8.1.
>
> I look forward to hearing from you soon...
>
> Thanks in advance...
>
> George
Received on Wed Nov 06 2002 - 14:41:04 CST