Neoview Script Guide (R2.2)

Syntax
SHOW TIMING
Considerations
In the Neoview Script interface, you must enter the command on one line. The command does
not require an SQL terminator.
Example
This command shows that the setting for the elapsed time is OFF:
SQL>show timing
TIMING OFF
SHOW VIEWS Command
The SHOW VIEWS command displays all or a set of the views that exist in the current schema
of the Neoview Script session.
Syntax
SHOW VIEWS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display views with names that match the character
string. wild-card-pattern matches an uppercase string unless you enclose it within
double quotes. To look for similar values, specify only part of the characters of
wild-card-pattern combined with these wild-card characters:
Use a percent sign to indicate zero or more characters
of any type. For example, %art% matches SMART,
ARTIFICIAL, and PARTICULAR but not smart or
Hearts. "%art%" matches smart and Hearts but not
SMART, ARTIFICIAL, or PARTICULAR.
%
Use an underscore to indicate any single character. For
example, boo_ matches BOOK and BOOT but not BOO or
BOOTS. "boo_" matches book and boot but not boo
or boots.
_
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• You can execute this command only in SQL mode.
• If you do not specify a wild-card pattern in a SHOW VIEWS command, Neoview Script
displays all the views (not materialized views) that exist in the current schema.
• If you specify a wild-card pattern in a SHOW VIEWS command, Neoview Script displays
only the view names that match the wild-card pattern.
Examples
• This command shows all the views that exist in the current schema, SALES:
SQL>show schema
SCHEMA INVENT
SQL>show views
136 Neoview Script Interface Commands