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

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.
• If you specify a wild-card pattern in a SHOW VIEWS command, NCI displays only the view
names that match the wild-card pattern.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
• This command shows all the views that exist in the current schema, SALES:
SQL>show schema
SCHEMA INVENT
SQL>show views
VIEW NAMES
-------------------------------------------------------------
VIEW207 VIEW207N VIEWCS VIEWCUST
SQL>
• This command shows the views in the current schema, INVENT, that have “VIEW” at the
beginning of their names:
SQL>show views view%
VIEW NAMES
-------------------------------------------------------------
VIEW207 VIEW207N VIEWCS VIEWCUST
SQL>
For more information, see “Showing the Views in a Schema” (page 67).
SPOOL Command
The SPOOL command logs the entered commands and their output from the NCI to a log file.
SPOOL Command 151