Re: easy connect string

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 14 Oct 2006 18:20:07 +0100
Message-ID: <qp62j25loildosunl1jvdmfooqf3biut46@4ax.com>

On Sat, 14 Oct 2006 12:30:57 -0400, "klabu" <nosuchuser_at_gmail_dot_com> wrote:

>10gR2, XE
>
>regarding the "easy connect string":
>$ sqlplus klabu/mypw@//xebox:1521/xe
>
>Is there a way to use it WITHOUT entering password in the visible command
>line ?

The following is how to do it; it's certainly not the first thing that comes to mind though. Basically, make sure that the "easy connect string" is quoted:

$ sqlplus test@\"excession:1521/xe\"

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 14 18:18:31 2006

Enter password: test

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Sat Oct 14 2006 - 12:20:07 CDT