Re: Easy question for scripts

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> _at_script argument1

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:
> _at_echo on
> svrmgr30 _at_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 - 18:21:31 CEST