Here are some useful code fragments:
Here is example of 3 situations which can happen when using statement 'select column into variable where .. '
How to monitor progress of DML operations? Here is the solution.
Here you may find very nice article about differences between popular MySQL database and Oracle. The article was written by Oracle itself.