PL/SQL - Naming Convention

Naming Convention

PL/SQL Packages   : <name>_API
PL/SQL Procedures : <name>_PRC
PL/SQL Functions  : <name>_FUN

PL/SQL variables:

    Package Global Variables: g_variable_name
    Local Variables         : l_variable_name
    Types                   : t_type_name
    Cursors                 : c_cursor_name
    Exceptions              : e_exception_name
    Input Parameters        : i_parameter_name
    Outut Parameters        : o_parameter_name
    In/Out Parameters       : io_parameter_name

Documentation / Reference

See also: naming convention for oracle