SQL-editors prompt for variables prefixed with ‘&’ in SQL statements
disable ampersand (kaufmännisches und) ‘&’ with “set define off” in TOAD or SQL*Plus
set define off;
insert into PERSON(ID, NAME) values (1, ‘you & me’);
set define on;
use “execute as script” instead of “execute statement”
3 thoughts on “escape character & (ampersand) in oracle”
heute wieder gebraucht :)
saved my day! :) thx
thanx a lot.
Comments are closed.