Med Java

User Tools

Site Tools

Trace:
database:oracle:plsql-naming-conventions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
database:oracle:plsql-naming-conventions [2023/09/08 20:37] – odeftadatabase:oracle:plsql-naming-conventions [2023/09/08 20:38] (current) – odefta
Line 3: Line 3:
   - **Variables**:    - **Variables**: 
     * Local: prefix with ''l_'' (e.g., ''l_counter'').     * Local: prefix with ''l_'' (e.g., ''l_counter'').
-    * Global: prefix with ''g_'' (for those declared in a package specification).\\ +    * Global: prefix with ''g_'' (for those declared in a package specification).
   - **Parameters**:    - **Parameters**: 
     * Prefix with ''p_'' (e.g., ''p_emp_id'').     * Prefix with ''p_'' (e.g., ''p_emp_id'').
- 
   - **Cursors**:    - **Cursors**: 
     * Prefix with ''cur_'' (e.g., ''cur_employee'').     * Prefix with ''cur_'' (e.g., ''cur_employee'').
- 
   - **Constants**:    - **Constants**: 
     * Prefix with ''c_'' (e.g., ''c_max_value'').     * Prefix with ''c_'' (e.g., ''c_max_value'').
     * Uppercase for constants (e.g., ''MAX_VALUE'').     * Uppercase for constants (e.g., ''MAX_VALUE'').
- 
   - **Types**:    - **Types**: 
     * Prefix with ''t_'' (e.g., ''t_employee_table'' for a table type).     * Prefix with ''t_'' (e.g., ''t_employee_table'' for a table type).
- 
   - **Exception**:    - **Exception**: 
     * Prefix with ''ex_'' or ''err_'' (e.g., ''ex_no_data'').     * Prefix with ''ex_'' or ''err_'' (e.g., ''ex_no_data'').
- 
   - **Records**:    - **Records**: 
     * Suffix with ''_rec'' or ''_type'' (e.g., ''employee_rec'').     * Suffix with ''_rec'' or ''_type'' (e.g., ''employee_rec'').
- 
   - **Arrays/Collections**:    - **Arrays/Collections**: 
     * Suffix with ''_tbl'' or ''_list'' (e.g., ''employee_list'' or ''employee_tbl'').     * Suffix with ''_tbl'' or ''_list'' (e.g., ''employee_list'' or ''employee_tbl'').
- 
   - **Procedures/Functions**:    - **Procedures/Functions**: 
     * Procedures: use verbs (e.g., ''update_employee'', ''calculate_bonus'').     * Procedures: use verbs (e.g., ''update_employee'', ''calculate_bonus'').
     * Functions: names reflecting return value (e.g., ''get_employee_salary'').     * Functions: names reflecting return value (e.g., ''get_employee_salary'').
- 
   - **Boolean variables**:    - **Boolean variables**: 
     * Prefix with ''is_'', ''has_'', or ''can_'' (e.g., ''is_valid'', ''has_records'').     * Prefix with ''is_'', ''has_'', or ''can_'' (e.g., ''is_valid'', ''has_records'').
- 
   - **Tables/Views**:    - **Tables/Views**: 
     * Tables: use plural names (e.g., ''employees'').     * Tables: use plural names (e.g., ''employees'').
     * Views: prefix with ''v_'' or suffix with ''_view'' (e.g., ''v_active_employees'', ''employee_summary_view'').     * Views: prefix with ''v_'' or suffix with ''_view'' (e.g., ''v_active_employees'', ''employee_summary_view'').
- 
   - **Indexes**:    - **Indexes**: 
     * Prefix with ''idx_'' (e.g., ''idx_emp_name'').     * Prefix with ''idx_'' (e.g., ''idx_emp_name'').
- 
   - **Triggers**:    - **Triggers**: 
     * Reflect timing and event (e.g., ''before_insert_emp'').     * Reflect timing and event (e.g., ''before_insert_emp'').
- 
   - **Packages**:    - **Packages**: 
     * Name based on functionality (e.g., ''pkg_employee_operations'').     * Name based on functionality (e.g., ''pkg_employee_operations'').
database/oracle/plsql-naming-conventions.1694194628.txt.gz · Last modified: 2023/09/08 20:37 by odefta