RE: standards

I agree. Users don't need to know if something is a table or view (they
shouldn't know). 

True story from last week. Peoplesoft appends _VW to their views. On a recent
upgrade they decided a current view should become a table. Drop the view in the
DB and create the table. Of course that original view name is used in their code
so now their is a database table named _VW.

Bad idea.

Henry


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rachel Carmichael
Sent: Thursday, August 05, 2004 8:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: standards


only if you don't buy me enough drinks beforehand :)

now to get this back somewhat on topic...

I go back and forth on the idea of standards. You have to be able to
enforce them, and more importantly you have to abide by them yourself.
How many of us do things in the name of expediency that violate the
standards we've set.

One thing I've finally decided is fairly useless is the idea, within
naming standards, of identifying the type of object by a prefix. Who
cares?


--- Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:

> Make that 2 - though I'm a little worried she'll make us give
> examples
> of our own cretinous behaviour as a condition of entry.
> 
> 
> -- 
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
> 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: