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“
Letzte Kommentare