This one has served me well over the years , when you know you can do something with Oracle / PLSQL / Sql Plus , but can’t remember the exact syntax …
http://www.db.cs.ucdavis.edu/teaching/sqltutorial/tutorial.pdf
People, Technology and the Business of Software
Paul Browne 