Filter
Top Products
Examples
This command displays the value set for the markup option:
SQL>show markup
MARKUP RAW
SHOW MODE Command
The SHOW MODE command displays the operating mode of the current Neoview Script session.
The default is SQL.
Syntax
SHOW MODE
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 mode of the current session is CS:
>show mode
MODE CS
For more information, see “MODE Command” (page 92).
SHOW MVGROUPS Command
The SHOW MVGROUPS command displays all or a set of the materialized view groups in the
current schema of the Neoview Script session.
Syntax
SHOW MVGROUPS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display materialized view
groups 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.
_
116 Neoview Script Interface Commands