RE: SQl Help - use of special characters in a script when sending a password

From: Henslee, Jeff <jhenslee_at_wausauwindow.com>
Date: Thu, 7 Jul 2005 15:29:28 -0500
Message-ID: <3F02DCE8969E484482022C07D8CD6D9BE73172@waumail02.wausau.int>

WORKED!!! Thanks a bazillion!

Final output

$ sqlplus /nolog @/dbadmin/.lntappslogin.sql

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 7 15:24:13 2005

Connected.
SQL> $ more .lntapps* set escape on
connect lntapps/appl02vb\&21

-----Original Message-----

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Thursday, July 07, 2005 3:24 PM
To: Henslee, Jeff; Oracle-L_at_freelists.org Subject: RE: SQl Help - use of special characters in a script when sending a password

Oops, I forgot to put the "\" in the password. It should have been

set escape on
connect username/Blob21\&vb02

Regards,
Brandon

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Allen, Brandon Sent: Thursday, July 07, 2005 1:21 PM
To: jhenslee_at_wausauwindow.com; Oracle-L_at_freelists.org Subject: RE: SQl Help - use of special characters in a script when sending a password

Try this:

set escape on
conn username/Blob21&vb02

Regards,
Brandon

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Henslee, Jeff Sent: Thursday, July 07, 2005 1:16 PM
To: Oracle-L_at_freelists.org
Subject: SQl Help - use of special characters in a script when sending a password

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_at_wausauwindow.com

--

http://www.freelists.org/webpage/oracle-l

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 07 2005 - 15:35:20 CDT