Scope
The scope is the locality of reference.
Examples:
| Locality | Description | Example |
| g | Global | g_temp |
| l | Local | l_temp |
| p | Parameter | p_parm1 |
| icon | false |
|---|---|
| title | Table of Contents |
Type
TypeAnchor
Examples:
| Type | Description | Example | Comment |
| c | Constant | gc_loop_crn | Global constant |
| c | Constant | lc_loop_crn | Local Constant |
| c | Constant | pc_loop_crn | Parameter |
| v | Variable | gv_loop_crn | Global Variable |
| v | Variable | lv_loop_crn | Local Variable |
| v | Variable | pv_loop_crn | Parameter |
In addition to these scalar types, there are other data types that are supported by the PL/SQL language. They are aggregate data types, which are as follows:
| Type | Description | Example |
| cur | Cursor | gcur_student |
| vcr | Cursor(variable) | lvcr_student |
| tbl | Table | gtbl_student |
| rec | Record | ltrec_address |
Primary IdentifierAnchor
The primary identifier is the most important part of a name. This can be a single word or a phrase.
Examples: Account, Student, StuAddr, LearnerEnroll, etc.
ModifierModifier
A modifier further qualifies a primary identifier to make it more readable. These modifiers can either precede or succeed a primary identifier.
Examples:
| Primary Identifier | Modifier | Position | Variable |
| address | mailing | Precede | mailing_address |
| phone | home | Precede | home_phone |
| customer_name | last | Middle | customer_last_name |
Suffix
The suffix is used to qualify the identifier further to document the usage of the variable. For example, the suffix is used to denote the type of parameter, as in IN, OUT, or INOUT.
Examples:
| Type | Description | Example |
| i | Input only parameter | pv_num_items_i |
| o | Output only parameter | pv_sum_o |
| io | Both input and output | pv_sum_io |
IT Analytics, SVC4010, Contact Us