Find an online book to read, and there are plenty of them.

http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html

http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/a_samps.htm