Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to require a fully-qualified object name?

765266Apr 21 2010 — edited Apr 22 2010
The 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2010
Added on Apr 21 2010
14 comments
4,299 views