Hi All,
following are the some important points which should be kept in mind while dealing with insert, update, delete statement.
1) Always use update and delete statement in transaction i.e by using explicit commit.
2)Before executing update and delete statement, first create them on the basis of select satement.
3)Finally before executing the update and delete query on the production server always keep habit to execute it on the non-production server.