Re: Oracle within a Unix Script

From: Jason Judge <jason.judge_at_virgin.net>
Date: Mon, 18 Oct 1999 23:19:10 +0100
Message-ID: <7ug5p1$1ra$1@nclient15-gui.server.virgin.net>

Yes - a great feature and an annoyance all in one.

I don't think you can escape the dollars - they will always get expanded even when in quotes. Try preceding them with a back-slash '\' just in case I am wrong.

You could try putting the dollars themselves into variables for expansion. It won't get expanded twice:-

export TAB1='v$session'
sqlplus <<-ENDSQL

select *
from $TAB1;
ENDSQL Regards,

JJ
jason.judge_at_virgin.net Received on Mon Oct 18 1999 - 17:19:10 CDT