Oracle: DBMS_STANDARD

Functions and procedures

`applying_crossedition_trigger`
`client_ip_address`
`commit`
`commit_cm`
`database_name`
`deleting`
`des_encrypted_password`
`dictionary_obj_name`
`dictionary_obj_name_list`
`dictionary_obj_owner`
`dictionary_obj_owner_list`
`dictionary_obj_type`
`grantee`
`inserting`
`instance_num`
`is_alter_column`
`is_creating_nested_table`
`is_drop_column`
`is_servererror`
`login_user`
`ora_max_name_len_supported`
`original_sql_txt`
`partition_pos`
`privilege_list`
`raise_application_error`
`revokee`
`rollback_nr`
`rollback_sv`
`savepoint`
`server_error`
`server_error_depth`
`server_error_msg`
`server_error_num_params`
`server_error_param`
`set_transaction_use`
`sql_txt`
`sysevent`
`sys_gettriggerstate`
`updating`
`with_grant_option`

Subtypes

dbms_standard defines some subtypes:

subtype dbms_id            is varchar2(ORA_MAX_NAME_LEN  );
subtype dbms_quoted_id     is varchar2(ORA_MAX_NAME_LEN+2);
subtype dbms_id_30         is varchar2(30);
subtype dbms_quoted_id_30  is varchar2(32);
subtype dbms_id_128        is varchar2(ORA_MAX_NAME_LEN  );
subtype dbms_quoted_id_128 is varchar2(ORA_MAX_NAME_LEN+2);

dbms_id and dbms_quoted_id are used for identifiers of PL/SQL objects, user names, SQL identifiers.

ORA_MAX_NAME_LEN is a constant whose value is 128.

Oracle: DBMS_STANDARD

Functions and procedures

Subtypes

See also