Re: The dollar symbol in SQL script names and Unix
- From: "S. Anthony Sequeira" <tony@xxxxxxxxxxxxxxx>
- To: Oracle List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 06 May 2010 21:18:34 +0100
On 06/05/10 21:06, John Piwowar wrote:
Hi Tony,
In the bash shell, at least, it looks like the $ is interpolated if
not escaped, and confusing to SQL*Plus even if it is escaped.
Granted, this might be a peculiarity of the OS X SQL*Plus client.
zathras:SQL jpiwowar$ sqlplus jpiwowar@MACTEST @te$t.sql
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 6 16:00:36 2010
<header trimmed>
SP2-0310: unable to open file "te.sql"
zathras:SQL jpiwowar$ sqlplus jpiwowar@MACTEST @te\$t.sql
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 6 16:00:48 2010
<snip-snip>
SP2-0310: unable to open file "te$t.sql"
Regards,
John P.
Hi John,
Thanks for the reply.
Yes, if it's run on the command line, I can quite understand it. It
will happen with any Unix OS AFAIK.
But if it's run from within SQL*Plus?
Regards
--
Tony
Other related posts:
