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
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 57).
SPOOL Command
The SPOOL command logs the entered commands and their output from the Neoview Script
interface to a log file.
Syntax
SPOOL { ON [CLEAR] | log-file [CLEAR] | OFF }
130 Neoview Script Interface Commands