Dung noi cac ky tu || hoặc # hoặc \
insert into table1 values('&'||'hello world');
hoặc insert into d1 values ('a#&b');
hoặc table1 values('a\&b');
1 row created. select * from table1;
COL1
--------------------------------------------------
&hello world
a&b
Cách 2:
Có thể dùng SET SCAN OFF hoặc SET DEFINE OFF.
Khuyến cáo nên dùng SET DEFINE OFF thay cho SET SCAN OFF
SET DEFINE OFF;
insert into test2(x) values('&hello world');
1 row created.
commit;
Commit complete.
select * from test2;
X
---------------------------------------
&hello world
http://docs.oracle.com/cd/E11882_01/server.112/e16604/apc.htm#SQPUG142
SET SCAN {ON|OFF} (obsolete)
Controls scanning for the presence of substitution variables and parameters. OFF suppresses processing of substitution variables and parameters; ON enables normal processing.
ON functions in the same manner as SET DEFINE ON.
thaovannguyenngoc 