Set Define Off in Oracle

Oracle will ask you to enter the value if your UPDATE statement is written as below:

Update my_table Set my_field = 'You & I are good boy';

At the end, the value for my_field will not be updated even you have entered something.

To overcome this problem, you just need to add one more statement before the UPDATE statement:

Set Define Off;
Update my_table Set my_field = 'You & I are good boy';


NOTE: This topic also related to DELETE or INSERT INTO statement.