If we run a script or SQL that contains "&" symbols, for example when we try to insert some data into database, what actually happen is SQL Plus will prompt the user for a value.
In that case, we can use SET DEFINE OFF to stop SQL*Plus performing any variable substitution. This makes SQL*Plus treat all ampersands (&) as literal characters.
In that case, we can use SET DEFINE OFF to stop SQL*Plus performing any variable substitution. This makes SQL*Plus treat all ampersands (&) as literal characters.
