Re: SQLPLUS script

There is yet another possibility:

Create a directory to keep your Sql files in ( give the extension .sql to identify them, it makes thing easier )

Edit your registry ( carefully ) to add that directory to the HKEY_LOCAL_MACHINE..SOFTWARE.ORACLE..SQLPATH entry using a semi-colon to separate it from any existing entry(ies)....

Then you can just use:
( after connecting in SqlPLus )

SqlPLus > @my_file_name

HTH.. John Greco

Erika Grondzakova <Erika.Grondzakova_at_cern.ch> wrote:

>Hi,
>
>There are 2 possibilities:
>
>- in SqlPlus -> File -> Open and find the file you want to execute. and
>then again from the menu File -> Run.
>
>- or write directly in SqlPlus
>start drive:\directory_path\file.sql;
>
>HTH,
>
>Erika
>
>
>jag wrote:
>>
>> I am new in oracle ... and I want execute (in SQLPLUS) a text file with
>> commands in sql ... I think that it's possible but I don't know how.
>>
>> Can anyone help me??
>>
>> Thanks

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Oct 11 1999 - 11:40:04 CDT