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

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.

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 MVS command, Neoview Script displays

all the materialized views that exist in the current schema.

• If you specify a wild-card pattern in a SHOW MVS command, Neoview Script displays only

the materialized view names that match the wild-card pattern.

Examples

• This command shows all the materialized views in the current schema, PERSNL:

SQL>show mvs;

MATERIALIZED VIEW NAMES

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

mvemp1 mvemp2 mvemp3 mvjobdesc

SQL>

• This command shows all the materialized views in the current schema, PERSNL, that have

“EMP” in their names:

SQL>show mvs %emp%;

MATERIALIZED VIEW NAMES

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

MVEMP1 MVEMP2 MVEMP3

SQL>

• This command shows all the materialized views in the current schema, SALES, that are

named “ORDER” followed by one character:

SQL>show mvs "ORDER_"

MATERIALIZED VIEW NAMES

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

ORDER1 ORDER2 ORDERS

SQL>

SHOW PARAM Command

The SHOW PARAM command displays the parameters that are set in the current Neoview Script

session.

118 Neoview Script Interface Commands

1 2 ... 113 114 115 116 117 118 119 120 121 122 123 ... 141 142

Comentários a estes Manuais

Sem comentários

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

Comentários a estes Manuais

Manuais e produtos relacionados com Software HP NEOVIEW 544530-001