SQL*Plus (MOSC)

MOSC Banner

Treat @ and @@ as normal characters in sqlplus 10g

edited Oct 11, 2016 2:50PM in SQL*Plus (MOSC) 7 commentsAnswered ✓

Hello,

I am trying to perform an insertion as the follows (I put the command in a script called script1.sql):

INSERT INTO txt (str) VALUES

('line1

@line2

@line3

line4'

);

SQL> @d:\temp\script1.sql

SP2-0310: unable to open file "d:\temp\line2.sql"

SP2-0310: unable to open file "line3.sql"

1 row created.

SQL> select * from txt;

STR

-------------------------------------------------

line1

line4

How can I set SqlPlus to treat @ as normal characters when they are part of a text field and located at the beginning of a line?

Thank you for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center