HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 125)

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.

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 SYNONYMS command, Neoview

Script displays all the synonyms that exist in the current schema.

• If you specify a wild-card pattern in a SHOW SYNONYMS command, Neoview Script

displays only the synonym names that match the wild-card pattern.

Examples

• This command shows all the synonyms in the current schema, SALES:

SQL>show synonyms

SYNONYM NAMES

-------------------------------------------------------------

CUST DTLS ORDR PRTS

SQL>

• This command shows all the synonyms in the current schema, SALES, that have “S” at the

end of their names:

SQL>show synonyms %s

SYNONYM NAMES

-------------------------------------------------------------

DTLS PRTS

SQL>

• This command shows all the synonyms in the current schema, SALES, that are named “PRT”

followed by one character:

SQL>show synonyms "PRT_"

SYNONYM NAMES

-------------------------------------------------------------

PRTS

SQL>

SHOW TABLE Command

The SHOW TABLE command displays information about the indexes, materialized views, or

synonyms of a specified table or materialized view.

SHOW TABLE Command 125

1 2 ... 120 121 122 123 124 125 126 127 128 129 130 ... 141 142

Comentários a estes Manuais

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 125

Comentários a estes Manuais

Manuais e produtos relacionados com Software HP NEOVIEW 544530-001