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 “execute as script” instead of “execute statement”

Advertisements

3 thoughts on “escape character & (ampersand) in oracle

Comments are closed.