Neoview Command Interface (NCI) Guide (R2.4)

SHOW TIMING Command
The SHOW TIMING command displays whether the setting for the elapsed time is ON or OFF.
Syntax
SHOW TIMING
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
• This command displays the elapsed time information because the SET TIMING command
is enabled:
SQL>set timing on
SQL>show time
TIME OFF
Elapsed :00:00:00.000
SHOW VIEWS Command
The SHOW VIEWS command displays all or a set of the views that exist in the current schema
of the NCI 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 asterisk (*) 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.
_
Use a question mark (?) 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
• 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, NCI displays all the
views (not materialized views) that exist in the current schema.
154 NCI Commands