Oracle SQL Developer

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

Comment

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *