RE: standards
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Aug 2004 10:21:24 -0400
Why didn't they just recreate the view that did a select * from the table?
Sounds like a "quick fix" instead of a slow thought.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Poras, Henry R. [mailto:Henry_Poras@xxxxxxxxxxxxxxxx]
Sent: Friday, August 06, 2004 10:17 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: 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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
