How to enter special characters like “&” in oracle database

SQL> create table student(id number,name varchar2(30),Description varchar2(100));

SQL> insert into student(id,name,Descrtiption) values(1,'Munna','Smart & Positive');

Enter value for positive:

Asking for input.

Solution:

SQL> set define off

SQL> insert into student(id,name,Description) values(1,'Munna','Smart & Positive');

1 row created.

Or

 SQL> set escape on

SQL> insert into student(id,name,Description) values(1,'Munna','Smart \& Positive');

1 row created.

Comments