How to require a fully-qualified object name?
765266Apr 21 2010 — edited Apr 22 2010The IT department where I work requires that all table names involving SQL include the schema - for example, instead of "SELECT stuff FROM table", it must be "SELECT stuff FROM *schema*.table".
We have several analysts who submit SQL code to IV&V that works just fine, except that somewhere in the code the developer forgot to include the schema name. IV&V rejects this, which costs a couple of days' time on the implementation schedule.
Is there a switch or SET command, or anything remotely similar, that can be set in SQLPlus, SQL Developer, etc. that will raise an error if the schema name is not specified with the object? Something akin to Perl's "use strict" will be fine. Basically I'm looking for something that our analysts can use that will catch this sort of thing upfront before IV&V does, which costs far too much time.