Tips on executing the PL/SQL Query

Issue:
Sometimes, When You are executing the PL/SQL query, it may end up with error by constraints problem.

Note:

The thing to be noted is, the some queries may get partially executed and altered the table.
If You are trying to run the same PL/SQL again, it will surely end up with some error if and only if the Table having constraints.