Re: object naming conventions

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3F02EC8A.ED51CB57_at_remove_spam.peasland.com...
> Ouch!!!! Isn't that what the schema name is for?
>
> select call_description
> from HDW.call
> where call_id=1234;
>
> But I suppose I'm putting too much intelligence in the mix. We need to
> dumb down things so that the end user can create ad-hoc queries without
> having to think too much.......
>
> Cheers,
> Brian

Well actually the ad-hoc query tool gives the identifiers *without* the suffix, so as a DBA you get queries like " can you see if there are any orphaned records in the call table?" . But yes I agree with you.

It may or may not be coincidence that the 'W' stands for 'Windows' :(

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************