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

Syntax
SHOW ALIAS [alias-name | wild-card-pattern]
alias-name
is any alias name that is used with the ALIAS command. See “ALIAS Command” (page 89).
wild-card-pattern
is a character string used to search for and display aliases 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.
Examples
This command displays a list of the available aliases:
SQL> SHOW ALIAS
.OS AS LH
.GOTO AS GOTO
USE AS SET SCHEMA
This command displays the .GOTO alias:
SQL> SHOW ALIAS .GOTO
.GOTO AS GOTO
This command displays the .FOO alias:
SQL> SHOW ALIAS .FOO
No aliases found.
This command displays all aliases beginning with the letter “S”:
SQL> SHOW ALIAS S*
SEL AS SELECT
SHOWTIME AS SHOW TIME
ST AS SHOW TABLES
SHOW ALIASES Command
The SHOW ALIASES command displays all the aliases available in the current NCI session.
134 NCI Commands