The example in theCoding Style chapter has a syntax error.

The formatter does not throw an error because SQLDev's parser can handle this syntax. However, db* CODECOP cannot and neither can the Oracle Database (it throws an "unknown command on line 1" error).

So, I suggest to add acreate or replace to fix the issue.