RE: standards

From: Poras, Henry R. <Henry_Poras_at_dfci.harvard.edu>
Date: Fri, 6 Aug 2004 10:17:19 -0400
Message-ID: <0D3AAB332E29BA4F9D8BE559F244A91403B84B79@phsexch27.mgh.harvard.edu>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rachel Carmichael Sent: Thursday, August 05, 2004 8:18 PM
To: oracle-l_at_freelists.org
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_at_gmail.com> 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_at_freelists.org 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_at_freelists.org
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
-----------------------------------------------------------------

Received on Fri Aug 06 2004 - 09:14:06 CDT