How to insert the '&' character into table which is between in a string
SQL> create table s(ss varchar(10));
Table created.
SQL> insert into s values('2 & 3');
Enter value for 3:
old 1: insert into s values('2 & 3')
new 1: insert into s values('2 ')
1 row created.
SQL> select * from s;
SS
----------
2
SQL> drop table s;
Table dropped.
SQL> create table s(ss varchar2(10));
Table created.
SQL> insert into s values('2 & 3');
Enter value for 3:
old 1: insert into s values('2 & 3')
new 1: insert into s values('2 ')
1 row created.
SQL> select * from s;
SS
----------
2
SQL> drop table s;
Table dropped.
SQL> create table s(ss nvarchar2(10));
Table created.
SQL> insert into s values('2 & 3');
Enter value for 3:
old 1: insert into s values('2 & 3')
new 1: insert into s values('2 ')
1 row created.
SQL> select * from s;
SS
----------
2
SQL> drop table s;
Table dropped.
SQL> create table s(ss char(10));
Table created.
SQL> insert into s values('2 & 3');
Enter value for 3:
old 1: insert into s values('2 & 3')
new 1: insert into s values('2 ')
1 row created.
SQL> select * from s;
SS
----------
2
SQL> drop table s;
Table dropped.
SQL> create table s(ss nchar(10));
Table created.
SQL> insert into s values('2 & 3');
Enter value for 3:
old 1: insert into s values('2 & 3')
new 1: insert into s values('2 ')
1 row created.
SQL> select * from s;
SS
----------
2
Edited by: user10438587 on 06-Jan-2009 07:57