oracle – Check if the schema name is included in each sentence

I got Oracle database scripts to create the entire database of an application, including sentences to create tables, sequences, synonyms, insertions and data updates, etc.

I have to make sure that all these sentences have the name of the schema before the name of the table, for example.


I have to check this for every sentence, whether it's creations, insertions, foreign keyphrases, and so on.

And here's the question: "Is there a way to do this kind of audit? maybe through the sqldeveloper tool setting a specific configuration?

Maybe the right question here could also be, if there is a way to run the script and display an error when the executed sentence does not have the schema name included?

Thanks in advance.