It may be a bit dated, but there is some good information in this Oracle Database cert guide. With a lot of Oracle-specific stuff too. Maybe try and find a more up-to-date version or the equivalent.
OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press) https://a.co/d/dhRYsuL