Did you try Oracle's own documentation already? It is freely available to anybody, and probably as comprehensive as it gets..
I'd suggest starting with the
Concepts to get rough ideas about how Oracle works and what can be done with it, and then continuing with
SQL Language Reference and
PL/SQL Language Reference.
All of these can be found here for 11.1, but look up the version matching the database you are working with.