Re: The dollar symbol in SQL script names and Unix
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: tony@xxxxxxxxxxxxxxx
- Date: Thu, 6 May 2010 17:30:17 -0400
Well, what do you know?
Third times the charm!
SQL> !ls
a$a.sql
SQL> !cat *
select sysdate from dual;
SQL> !cat a$a.sql
cat: cannot open a.sql
SQL> @a$a.sql
SP2-0310: unable to open file "a$a.sql"
SQL> @a\$a.sql
SP2-0310: unable to open file "a\$a.sql"
SQL> @a\\$a.sql
SP2-0310: unable to open file "a\\$a.sql"
SQL> @a\\\$a.sql
SYSDATE
---------
06-MAY-10
On Thu, May 6, 2010 at 4:42 PM, S. Anthony Sequeira <tony@xxxxxxxxxxxxxxx>wrote:
> On 06/05/10 21:35, John Piwowar wrote:
>
>> Whoops, incomplete copy and paste! I'm AFK now, but when I tried to
>> run the script from within SQL*Plus, I got the same "unable to open
>> file" message.
>>
>> Regards,
>>
>> John P.
>>
>>
> I'd be interested to see a cut and paste of such a session, when you are
> able to please.
>
> Or even a spool file.
>
> Cheers
>
> --
> Tony
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
