Avoid Substitution Variable in Oracle:
Whenever we try to execute a Query/plsql block having ampersand chracter(&) which tells oracle that you want to use a substitution variable. This can be avoided by calling below statement before the query/plsql block.
SQL> SET DEFINE OFFSQL> insert into javanib values(11,'Michle & Clarke'); 1 row created
Example : Alternatively we can use pipe(||) symbol in your insert statements.
SQL> insert into javanib values(11,'John &'|| ' Scena'); 1 row created.
Example : or disable scanning for substitution variables entirely:
SQL> SET SCAN OFFSQL> insert into javanib values(12,'Rajini & Kanth'); 1 row created.
Example :
No comments:
Post a Comment