Usage: LIST type pattern

TYPE  :
  OBJECT CLUSTER INDEX SEQUENCE SYNONYM TABLE TRIGGER
  TYPE VIEW MVIEW TABPART INDPART SEGMENT REBUILD LOB QUEUE
PATTERN:
  user.name (''_'' as any one char, ''%'' as any string)

　　1,LIST OBJECT

    这个命令从ALL_OBJECTS视图查询数据, 如我们要查询SCOTT用户下包括"TEST"字符的所有对象(如果不写 "SCOTT." 则表示查询所有的用户下的包括有TEST字符的对象):

ASQL> LIST OBJECT SCOTT.%TEST%

TYPE      ID OWNER OBJECT_NAME  CREATED    MODIFIED  STATUS
------- ---- ----- ------------ ---------- ---------- ------
TABLE  6320 SCOTT PI_TEST      2006/01/16 2006/01/17 VALID
TRIGGER 6321 SCOTT PI_TEST_TRG  2006/01/16 2006/01/17 VALID
TRIGGER 6325 SCOTT PI_TEST_TRG2 2006/01/17 2006/01/17 VALID

3 rows returned.