For the most accurate and up-to-date syntax, official manuals are the gold standard. Oracle Database SQL Language Reference (23c)