Re: create dblink with & in password??

In article <32d53ca0.335768759_at_203.12.176.153>, George Dau <gedau_at_mim.com.au> writes
>G'day Oraclers,
>The SQL Language Reference Manual says on pages 2-9, then shows in an example on
>2-10 that I can use an & in an object if I double quote the name.
>
>Doesnt work with a database link under Oracle 7.2.2. Here is my script:
>
>#!/bin/sh
>sqlplus system/manager <<EOSQL
>create database link oen.prod
> connect to oen identified by "safety&1st"
> using 'T:bcscost1:OENP';
>xit;

You can put almost anything in an object name if you double quote it, but the SQL*Plus command line interpreter will assume the & marks the start of a variable. You need to disable or change the variable character using SET DEFINE (see the SQL*PLus User's Guide)

-- 
Jim Smith