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. |