Hi,
I'm using following convention (and it cannot be used in PL/SQL developer):
1) packages/procedures/functions/etc. that are not part of my project: upper case
2) system packages are within group (1)
3) local variables starts with lower case and use camel notation later
4) Table names, column names - I use camel notation
5) procedures that are part of my project use lower case
PL/SQL beautifier lacks the following:
a) To set different case based on the items that are within current project
b) To use camel notation started with lower case letter
You cannot set beautifier rules to make uppercase for DBMS_APPLICATION_INFO.SET_MODULE while having other package names/procedure names lowercase (in fact strange things would happen if you enter such names with dot into the beautifier custom names window)
I'm using following convention (and it cannot be used in PL/SQL developer):
1) packages/procedures/functions/etc. that are not part of my project: upper case
2) system packages are within group (1)
3) local variables starts with lower case and use camel notation later
4) Table names, column names - I use camel notation
5) procedures that are part of my project use lower case
PL/SQL beautifier lacks the following:
a) To set different case based on the items that are within current project
b) To use camel notation started with lower case letter
You cannot set beautifier rules to make uppercase for DBMS_APPLICATION_INFO.SET_MODULE while having other package names/procedure names lowercase (in fact strange things would happen if you enter such names with dot into the beautifier custom names window)