Re: standards

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Thu, 5 Aug 2004 17:37:28 -0700 (PDT)
Message-ID: <20040806003728.27928.qmail@web50610.mail.yahoo.com>

Hi,

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?
>
...

Good point for discussion. Is it a degree of how much detail?

I prefer to prefix my PL/SQL function/procedure parameters with 'p_' to help with code maintenance and error prevention.

Because, a mis-understanding can arise when a parameter name matches a name in a SQL query. The 'p_' helps in these few cases.

2) I think its well documented that complex variable prefixes *hurt* understanding of code. I typically use simple variable prefixes to show basic scope.

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.

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 Thu Aug 05 2004 - 19:33:14 CDT