Was this helpful?
Wildcards and Help
You can use the asterisk (*) wildcard to specify all or part of the owner or object name parameters in a help statement. The help statement displays only objects to which the user has access, which are:
Objects owned by the user
Objects owned by other users who have granted permissions to the user
Objects owned by the DBA to which you have access
If you specify wildcards for both the owner and object name (*.*), help displays all objects to which you have access. To display help information about objects you do not own, you must specify the owner name, using the schema.objectname syntax. For details about schemas, see the SQL Reference Guide.
If you omit the owner name wildcard (that is, specify * instead of *.*), help displays the objects you can access without the owner prefix. The following examples illustrate the effects of the wildcard character:
help *
Displays objects owned by the session's effective user
help davey.*
Displays all objects owned by "davey"
help *.mytable
Displays all objects named "mytable" regardless of owner
help d*.*
Displays all objects owned by users beginning with "d"
help *.d*
Displays all objects beginning with "d" regardless of owner
help *.*
Displays all objects regardless of owner
Last modified date: 06/08/2023