Re: How can I : Connect in SQL*Plus using defined variables

"Claus" <clkhm_at_hotmail.com> writes:

> Hi there.
>
> In SQL*Plus I am trying to do the following
>
> DEFINE system_user_password = manager
> DEFINE connect_string = mydb
>
> connect system/&system_user_password_at_&connect_string
>
> Why are the variables in the line above not substituted and what should I do
> to make it work.

,----[ Test session ]

| SQL> define pwd=tiger
| SQL> define srv=first
| SQL> connect scott/&pwd_at_&srv;
| Connected.
| SQL> 

Works fine for me. What is your error message? Harald Received on Thu Oct 30 2003 - 17:20:36 CET