Oracle Substitution use at SQL Developer:
To define a character for substitution at sqldeveloper: SET DEFINE &;
here '&' is substitution character. if any insert/update/delete/select statement get '&' then it will ask substitution string.
To off bind or substitution scan at insert/update/delete/select at sqldeveloper use following command:
SET SCAN OFF;
To set a escape character use following command: SET ESCAPE \;
