Tag Archives: escape character

escape character & (ampersand) in oracle

SQL-editors prompt for variables prefixed with ‘&’ in SQL statements disable ampersand (kaufmännisches und) ‘&’ with “set define off” in TOAD or SQL*Plus e.g. set define off; insert into PERSON(ID, NAME) values (1, ‘you & me’); set define on; use … Continue reading

Posted in howtos | Tagged , , | 3 Comments