http://oracle-help.com/oracle-database/how-select-statement-works/
How Select Statement Works