From oracle-l-bounce@freelists.org Thu Jul 7 15:25:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j67KOx7h020350 for ; Thu, 7 Jul 2005 15:25:00 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j67KOuIP020332 for ; Thu, 7 Jul 2005 15:24:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B73C1CADFC; Thu, 7 Jul 2005 15:22:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25815-08; Thu, 7 Jul 2005 15:22:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 20A151C95A1; Thu, 7 Jul 2005 15:22:00 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Priority: normal Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: SQl Help - use of special characters in a script when sending a password Date: Thu, 7 Jul 2005 13:21:16 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C450236122C@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SQl Help - use of special characters in a script when sending a password thread-index: AcWDMMGS/3rxsQywRMy7LKZgnigSMQAAJp5A From: "Allen, Brandon" To: , X-archive-position: 22214 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Try this: set escape on conn username/Blob21&vb02 Regards, Brandon -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Henslee, Jeff Sent: Thursday, July 07, 2005 1:16 PM To: Oracle-L@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: ..login.sql and contain: connect username/password when I execute sqlplus I use: $ sqlplus -s /nolog @.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@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