Re: Easy question for scripts

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 30 Aug 1999 12:21:31 -0400
Message-ID: <7qejcd$jrj$1@autumn.news.rcn.net>

Hi Jorge,

    Try the following:

               connect system/manager
             alter database rename global_name to '&1 ';

    The substitution character is &. &1 is the first parameter, &2 the second parameter, etc.

    The general form for invoking a SQL*Plus script from the OS command line is:

                sqlplus <user>/<password> @script argument1

argument2

regards
Jerry Gitomer

Jorge wrote in message <7qe497$2mk$1_at_diana.bcn.ttd.net>...
>Hi:
> Can I request data from users to generate a script??
>
>Ex:
>
> I have a bat file:
> @echo on
> svrmgr30 @global.sql
> And the script file
> connect system/manager
> alter database rename global_name to ' VAR1 '
>
> Can I request var1 from the command line?? or maybe how can
I pass
>parameters to my scripts files???
>
>THANKS
>
>
>
Received on Mon Aug 30 1999 - 11:21:31 CDT