In ALL_ARGUMENTS table lists the arguments of the procedures and functions that are accessible to the current user
In DBA_ARGUMENTS table lists the arguments of the procedures and functions that are available in the database.
In USER_ARGUMENTS table lists the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column.
select distinct owner , package_name,object_name, argument_name, data_type, in_out, data_length,
character_set_name, type_owner, type_name, type_subname, pls_type, char_length, char_used from all_arguments
In DBA_ARGUMENTS table lists the arguments of the procedures and functions that are available in the database.
In USER_ARGUMENTS table lists the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column.
select distinct owner , package_name,object_name, argument_name, data_type, in_out, data_length,
character_set_name, type_owner, type_name, type_subname, pls_type, char_length, char_used from all_arguments
No comments:
Post a Comment