Treat @ and @@ as normal characters in sqlplus 10g
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
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.