CODEWITHSUNDEEP
oracle-databasesqlplus
hippocrene
hippocrene

Reputation: 84

Escape 'At sign' (@) in Oracle SQLPlus script filename

When trying to execute a script in SQLPlus that has an "At Sign" (@) in the filename, the @ symbol is expanded to the SID:

SQL> @ [email protected] SP2-0310: unable to open file "fooorclbar.sql"

SQL> START [email protected] SP2-0310: unable to open file "fooorclbar.sql"

Is there a way to escape the @ symbol in SQLPlus?

Upvotes: 3

Views: 1522

Answers (1)

Nick Krasnov
Nick Krasnov

Reputation: 27251

Set escchar SQL*PLUS system variable to @.

SQL> set escchar @

Here is an example:

File [email protected] contains select 1 from dual statement;

SQL> @[email protected]

         1
----------
         1

Upvotes: 3

Related Questions