select owner,
object_name,
decode(object_type,
'SYNONYM',
'同义词',
'TRIGGER',
'触发器',
'VIEW',
'视图',
'FUNCTION',
'函数',
'PACKAGE',
'包',
'PACKAGE BODY',
'包体',
'PROCEDURE',
'存储过程',
object_type) 对象
--,decode(object_type,'TRIGGER','触发器',object_type)
from dba_objects
where status != 'VALID'
and owner != 'SYS'
and owner != 'SYSTEM' order by 对象;
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12591949/viewspace-1032347/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12591949/viewspace-1032347/