Re: SQl Help - use of special characters in a script when sending a password
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 7 Jul 2005 16:24:35 -0400
in the login.sql, bracket the connect line with
set scan off
and
set scan on
The sqlplus command "set scan" controls whether sqlplus looks for the
defined substitution character.
On 7/7/05, Henslee, Jeff <jhenslee@xxxxxxxxxxxxxxxx> wrote:
> Apologies for the simple question - but I'm having a total brain fart.
> ======
> Oracle 8.1.74 and Solaris 8
> I have a file which I use in scripts to connect as a certain user. They are
> set to be available to only the oracle user and members of the dba group.
>
> basically, they are hidden files and called:
> .<username>.login.sql
> and contain:
> connect username/password
>
> when I execute sqlplus I use:
> $ sqlplus -s /nolog @.<username>login.sql
>
> My problem is that I have a user password that contains a '&' character.
>
> (Example:)
> connect username/Blob21&vb02
>
> How can I code in the '&' character into my script and NOT have sqlplus think
> it is a variable? Anybody ever run into this?
>
> I know that in SQL you can use something like:
>
> select field1, field2
> from foo
> where code like '%\_%' escape '\'
>
> How can I do it in a password (file) in my example?
>
> Please advise.
>
> Many Thanks!
>
> Jeffrey C. Henslee
> mailto:jhenslee@xxxxxxxxxxxxxxxx
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
