RE: CamelCase For Procedures Names

  • From: Jeff Chirco <JChirco@xxxxxxxxxx>
  • To: "Joel.Patterson@xxxxxxxxxxx" <Joel.Patterson@xxxxxxxxxxx>, "andy@xxxxxxxxxxxxxxx" <andy@xxxxxxxxxxxxxxx>, "kennethnaim@xxxxxxxxx" <kennethnaim@xxxxxxxxx>
  • Date: Mon, 21 May 2012 15:11:26 +0000

Thanks.  I agree the example Andy gave pretty much summed it up. Plus the fact 
that auto formatters may destroy the case later down the road.
And although I agree about adding "get" for functions we still do it.  It is 
hard to avoid plus when you are looking at a package it is easier to spot 
functions verses procedures.

-----Original Message-----
From: Joel.Patterson@xxxxxxxxxxx [mailto:Joel.Patterson@xxxxxxxxxxx] 
Sent: Monday, May 21, 2012 6:01 AM
To: andy@xxxxxxxxxxxxxxx; kennethnaim@xxxxxxxxx
Cc: Jeff Chirco; Oracle-L@xxxxxxxxxxxxx
Subject: RE: CamelCase For Procedures Names

I like the example, it pretty much says it all (43 chars though).   

What about suffixes or prefixes like R_for_procedures (or _R), or P_for 
packages, I did not catch Steve mentioning Packages and Package declarations in 
the paper?  (btw I don't believe tables need a prefix or suffix).

I do like what Steve says about avoiding 'get' with regards to a function.

Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Andy Klock
Sent: Friday, May 18, 2012 9:11 PM
To: kennethnaim@xxxxxxxxx
Cc: JChirco@xxxxxxxxxx; oracle Freelists
Subject: Re: CamelCase For Procedures Names

The most important thing is consistency by a defined coding standard that 
everyone must follow.  I don't even think it's because it makes the code more 
readable (though it does) but more because it saves so much time not having to 
think about what and how to call stuff.
Developers should spend more time on the actual logic than whether or not to 
use CamelCaseWhichIsAnnoyingAsHellWithLongNames or easy_to_read_names.

An old friend and colleague (who I know is a lurker here:) turned our old team 
onto a document very much like this:

Make amendments to fit your taste.  For me it made all the difference in the 


> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Jeff Chirco
> Sent: Friday, May 18, 2012 5:39 PM
> To: oracle Freelists
> Subject: CamelCase For Procedures Names
> I am settling a debate about allowing CamelCase procedure names within 
> a package.


Other related posts: