Re: standards

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Fri, 6 Aug 2004 08:32:20 -0700 (PDT)
Message-ID: <20040806153220.12209.qmail@web50608.mail.yahoo.com>

Hi Rachel,

> --- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> ...
> > 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?
> >

...
> (stuff from me)
> I had *one* link with examples of simple PL/SQL
> variable prefixes, and a *second* link which argued
> against all PL/SQL prefixes (with the caveat to
> check
> the case #1 mentioned above). Both links were great.
>
> If I can find these two links again today or
> tomorrow
> I will post them to the list.

I found the first link, and its already been mentioned. Download and extract "standards.doc":

ftp://ftp.oreilly.de/pub/ora/examples/oracle/orbestprac/examples.zip

I prefer to follow this, e.g. simple prefixes.

2) I could not find the second link, which was a PL/SQL standards document calling for no prefixes. It was very good, and I think it was posted at a university? Instead, I found a link that was similar:

http://ugweb.cs.ualberta.ca/~c391/manual/chapt9.html

If one looks under the "Naming Conventions" there are good examples of possible variable scope problems with no prefixes.

HTH Regards,

Mike Thomas

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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
-----------------------------------------------------------------

Received on Fri Aug 06 2004 - 10:30:08 CDT