I am working on Oracle Spatial 11g and I am referring to Oracle docs as a learning resource.
Does any one know any more Oracle Spatial tutorials?
We want to integrate Oracle Spatial data with ArcGIS and QGIS.
This question has been converted to Community Wiki and wiki locked because it is an example of a question that seeks a list of answers and appears to be popular enough to protect it from closure. It should be treated as a special case and should not be viewed as the type of question that is encouraged on this, or any Stack Exchange site, but if you wish to contribute more content to it then feel free to do so by editing this answer.
I suggest starting with this excellent pdf for the conceptual aspects:
Then move onto the dev guide (11gR2 here, about 900 pages worth):
At that point you'll be informed enough to integrate Oracle Spatial professionally into any Desktop GIS application. Specifically for ArcGIS, here's the ground rules and documentation for using SDO_Geometry within ArcSDE geodatabases: