Re: Substitutions

From: RP DATA SOLUTIONS <rpdata_at_cyberus.ca>
Date: Fri, 31 Jul 1998 21:47:02 GMT
Message-ID: <35c23ae1.102053655@news.cyberus.ca>

Use double ampersands... &&username...

"Gocha Mchedlishvili" <gocham_at_mci2000.com> wrote:

>I want to make SP, which propts for user name and password and then creates
>the user
>I wrote the code
>
>CREATE USER &UserName IDENTIFIED BY &PWord
>GRANT CREATE ANY TABLE TO &UserName
>
>When I run this script, I'm prompted twice for username.
>
>How to make it to prompt it only once?
>
>Thanks
>
>Gocha
>
>
>
>
>
Received on Fri Jul 31 1998 - 16:47:02 CDT