Oracle set define off, oracledefine

Oracle set define off, oracledefine

In SQL/Plus, the default value "&" indicates the substitution variable. That is to say, as long as the symbol appears in the command, SQL/Plus requires you to enter the substitution value.
This means that you cannot input a string containing this symbol into the database or assign it to a variable.
For example, if the string "You & I" is understood as a string starting with "You", it prompts You to enter the value of substitution variable I. If You enter I, the final string is converted to "YouI ".

Set define off disables this function. "&" is used as a common character. In the preceding example, the final character is "You & I"