PLSQL Coding Conventions

[Sharad Agarwal]

Are there any 'standard' coding conventions for authoring PLSQL code? While Java has a slew of conventions, most of them are very similar. Most Java IDE's will offer features to help follow a standard of choice, within the limits of what can be done automatically (code formatting, parts of the naming convention, etc).

I did search the forum, but did not find anything relevant. I also used Google, but could not find anything promising.

Thanks in advance.

[Jeanne Boyarsky]

Sharad,
I don't know of any definitive standards document, but RedHat's PL/SQL standards are pretty much in line with what I've done.

[Sharad Agarwal]

Thank you, Jeanne. This is useful. Most of my google searches led to articles by Steven Feuerstein, who seems to be amongst the few who are pretty big on having consistency in style.

Here is an interesting link I found: PL/SQL Standards

[Jeanne Boyarsky]

Originally posted by Sharad Agarwal:
Here is an interesting link I found: PL/SQL Standards

That's the same link as I posted. Good to know it was useful.

[Sharad Agarwal]

Originally posted by Jeanne Boyarsky:

That's the same link as I posted. Good to know it was useful.

I apologize, I meant to post this.

[Jeanne Boyarsky]

That does look good. Thanks Sharad!