Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Easy question for scripts

Re: Easy question for scripts

From: Aram Meguerian <aram.meguerian_at_tess.net.br>
Date: Thu, 2 Sep 1999 13:54:02 -0300
Message-ID: <D0yz3.1017$3Z2.35232@typ11a.deja.bcandid.com>

   In SQL*Plus you can use the ACCEPT command. Like:

ACCEPT my_var PROMPT "My var ?"
ALTER DATABASE RENAME GLOBAL_NAME TO '&my_var';

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 Thu Sep 02 1999 - 11:54:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US