8. SQL Statements : HELP : Wildcards in Help Statement
 
Share this page                  
Wildcards in Help Statement
The asterisk (*) wildcard can be used 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 that have granted permissions to the user
• Objects owned by the DBA to which you have access
If wildcards are specified 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, specify the owner name (using the schema.objectname syntax). If the owner name wildcard is omitted (that is, * is specified instead of *.*), HELP displays the objects that can be accessed without the owner prefix.
The following examples illustrate the effects of the wildcard character:
Wildcard
Description
HELP *
Display objects owned by the effective user of the session.
HELP davey.*
Display all objects owned by davey.
HELP *.mytable
Display all objects named, mytable, regardless of owner.
HELP d*.*
Display all objects owned by users beginning with d.
HELP *.d*
Display all objects beginning with d regardless of owner.
HELP *.*
Display all objects regardless of owner.