create table test (name varchar2(35));
insert into test values ('hello&world');
I tried the escape character '\' but the system asks for a value of the substitution variable.
Solution:
set define off
create table test (name varchar2(35));
insert into test values ('hello&world');
press 'F5' to execute the above commands.
(OR)
insert into table1 values('&'||'hello world');
1 row created.
select * from table1;
COL1
--------------------------
&hello world
No comments:
Post a Comment