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