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

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.
Syntax
SHOW ALIASES
Considerations
You must enter the command on one line. The command does not require an SQL terminator.
Examples
This command displays all the aliases in the current NCI session:
SQL> SHOW ALIASES
.OS AS LH
126 NCI Commands