SQL Developer help enter a substitution variable
«Insert into CSE_DEPT.COURSE (COURSE_ID,COURSE,CREDIT,CLASSROOM,SCHEDULE,ENROLLMENT,FACULTY_ID) values (‘CSE-334′,’Elec. Measurement & Design’,3,’TC-212′,’T-H: 11:00-12:25 PM’,25,’H99118′);»
In SQL , » &» is interpreted as the beginning of a substitution variable .
3 possible solutions :
SET ESPACE ‘\’ , and use ‘\’ to scape & in you code exp: \&
SET SCAN OFF , disable scanning for substitution variables
SET DEFINE OFF; turn off substitution completely