& IN WHERE CLAUSE of oracle
I HAD SQL QUERY RUNNING ON SQL DEVELOPER IDE:

SELECT IC.ID FROM INSTITUTE_COURSE IC WHERE IC.NAME = 'CIVIL & ARCHITECTURE CAD';

Due to & in where clause, ide returns an error "Enter Substitution Variable".

If I remove & in String, query runs fine.

 
& IN WHERE CLAUSE of oracle
===

I HAD SQL QUERY RUNNING ON SQL DEVELOPER IDE:

SELECT IC.ID FROM INSTITUTE_COURSE IC WHERE IC.NAME = 'CIVIL & ARCHITECTURE CAD';

Due to & in where clause, ide returns an error "Enter Substitution Variable".

If I remove & in String, query runs fine.

 