Set define off statement

The default "&" in the set define off statement in SQL * Plus 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, the string "SQL & Plus" system will understand it as a string with the "SQL" header, it prompts you to enter the value of the substitution variable Plus. If you enter ABC, the final string is converted to "SQLABC ".
Set define off to disable this function. "&" is used as a common character. For example, the final character is "SQL & Plus" set define off the replace variable function set define on enable the replace variable function set define *. The default replace variable identifier is "*" (or set to other characters) www.2cto.com Example: set define offbeginupdate admin. tag set TYPE_ID = 2, SUBCATEGORY_ID = 10, UPDATED_BY = 'a & B ', CREATED_BY = 'a & B', CREATED_DATE = SYSDATE, UPDATED_DATE = SYSDATE WHERE TAG_ID = 2; END; /The author said "silence is gold medal ".