I got some oracle database scripts for creating the whole database of an application, including sentences for creating tables, sequences, synonyms, inserts and updates of data, etc
I need to ensure that all these sentences have the schema name before table name, e.g.
INSERT INTO SCHEMANAME.MYTABLE...
I need to check this for each sentence, regardless of whether they are creates, inserts, foreign keys sentences, etc.
And here is the question, ¿is there a way to do this kind of check? maybe through sqldeveloper tool setting a specific configuration?
Maybe the right question here could be also, if is there a way to execute the script and show an error when the executed sentence has not the schema name included?
Thanks in advance.